title: How to find entries in vertical table that have one column zeroed out without using Pivot
body: <p>I'm working with a large vertical database with millions of entries and need to find part number &amp; revision combinations where every Mvalue is zero.</p>
  <p><a href="https://i.stack.imgur.com/Xkrg0.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Xkrg0.png" alt="enter image description here" /></a></p>
  <p>In this simplified example, the result should be Part number 1234 Rev 0</p>
  <p>The vertical structure is causing me trouble but I assumed pivoting the data would be a bad idea due to the database size.</p>
  <p>Is there a way to do this without a Pivot?</p>