title: How to use GROUP BY to concatenate strings in SQL Server?
body: <p>How do I get:</p>
  
  <pre><code>id       Name       Value
  1          A          4
  1          B          8
  2          C          9
  </code></pre>
  
  <p>to</p>
  
  <pre><code>id          Column
  1          A:4, B:8
  2          C:9
  </code></pre>