title: SQL Conditional Case
body: <p>I have a table that lists items and a status about these items. The problem is that some items have multiple different status entries. For example.</p>
  
  <pre><code>HOST          Status
  1.1.1.1       PASS
  1.1.1.1       FAIL
  1.2.2.2       FAIL
  1.2.3.3       PASS
  1.4.2.1       FAIL
  1.4.2.1       FAIL
  1.1.4.4       NULL
  </code></pre>
  
  <p>I need to return one status per asset.</p>
  
  <blockquote>
  <pre><code>HOST          Status
  1.1.1.1       PASS
  1.2.2.2       FAIL
  1.2.3.3       PASS
  1.4.2.1       FAIL
  1.1.4.4         No Results
  </code></pre>
  </blockquote>
  
  <p>I have been trying to do this with T-SQL Case statements but can't quite get it right. 
  The conditions are any Pass + anything is a Pass, Fail+ No Results is a fail and Null is No Results.</p>