title: Concat groups in SQL Server
body: <p>If I have a table like this:</p>
  
  <pre><code>+------------+
  | Id | Value |
  +------------+
  | 1  | 'A'   |
  |------------|
  | 1  | 'B'   |
  |------------|
  | 2  | 'C'   |
  +------------+
  </code></pre>
  
  <p>How can I get a resultset like this:</p>
  
  <pre><code>+------------+
  | Id | Value |
  +------------+
  | 1  | 'AB'  |
  |------------|
  | 2  | 'C'   |
  +------------+
  </code></pre>
  
  <p>I know this is really easy to do in MySQL using GROUP_CONCAT, but I need to be able to do it in MSSQL 2005</p>
  
  <p>Thanks</p>
  
  <p>(Duplicate of <a href="https://stackoverflow.com/questions/273238/how-to-use-group-by-to-concatenate-strings-in-mssql">How to use GROUP BY to concatenate strings in SQL Server?</a>)</p>