title: sql server ALL keyword
body: <p>Say I have the following table:</p>
  
  <pre><code>ID  Value
  --  ----
  1   1
  1   1
  1   0
  2   1
  2   1
  </code></pre>
  
  <p>let us take the ID of 1. I need to check that all of the ID's that are 1 have a value of 1.
  If not, I need to return 'N/A'. In this case, since row 3 had a value of 0, I need to return 'N/A'</p>
  
  <pre><code>    select * from tbl1 where ID = 1 and value = 1
  </code></pre>
  
  <p>will not quite do it.</p>
  
  <p>I know SQL has the ALL keyword but not sure how to use it in this case</p>