title: Case statements to appear on the same row SQL Server
body: <p>Im having real difficulty with a query. </p>
  
  <p>The current query is </p>
  
  <pre><code>SELECT 
  min(ID),
  Date, 
  CASE WHEN (ID) = '111' then SUM(Column1) END AS [Outcome1],
  CASE WHEN (ID) = '222' then SUM(Column1) END AS [Outcome2],
  CASE WHEN (ID) = '333' then SUM(Column1) END AS [Outcome3],
  CASE WHEN (ID) = '444' then SUM(Column1) END AS [Outcome4]
  FROM Table1
  GROUP BY ID, Date
  </code></pre>
  
  <p>And the result produces </p>
  
  <pre><code>|  ID |     Date | Outcome1 | Outcome2 | Outcome3 | Outcome4 |
  |-----|----------|----------|----------|----------|----------|
  | 111 | 01/01/18 |       20 |   (null) |   (null) |   (null) |
  | 222 | 01/01/18 |   (null) |       20 |   (null) |   (null) |
  | 333 | 01/01/18 |   (null) |   (null) |       20 |   (null) |
  | 444 | 01/01/18 |   (null) |   (null) |   (null) |       20 |
  </code></pre>
  
  <p>However the result i am looking for is </p>
  
  <pre><code>|  ID |     Date | Outcome1 | Outcome2 | Outcome3 | Outcome4 |
  |-----|----------|----------|----------|----------|----------|
  | 111 | 01/01/18 |       20 |       20 |       20 |       20 |
  </code></pre>
  
  <p>I have tried grouping but i end up with a result with just outcome1 at 80. But i am looking for it to be displayed with the 4 outcome columns.</p>
  
  <p>Can anyone help me with this? Thanks</p>
  
  <p>SQL Fiddle - <a href="http://sqlfiddle.com/#!18/9516c/2" rel="nofollow noreferrer">http://sqlfiddle.com/#!18/9516c/2</a></p>