title: Select distinct multiple field without NULL
body: <p>I have a table with Value ID and Value</p>
  
  <pre><code>--------------
  | id | value |
  --------------
  |  1 |  NULL |
  --------------
  |  1 |     A |
  --------------
  |  2 |  NULL |
  --------------
  |  2 |  NULL |
  --------------
  |  3 |     B |
  --------------
  |  3 |     B |
  --------------
  |  3 |     B |
  --------------
  </code></pre>
  
  <p>I need to select distinct id and corresponding value from the table. When selecting the Id should be unique and if it is having multiple values in the value field it should retrieve only not NULL values</p>
  
  <p>So the result should be like below.</p>
  
  <pre><code>--------------
  | id | value |    
  --------------
  |  1 |     A |
  --------------
  |  2 |  NULL |
  --------------    
  |  3 |     B |
  --------------
  </code></pre>
  
  <p>How to achieve this? using SQL server 2005</p>