title: SQL select multiple rows in one column
body: <p>I have table <strong>TestTable</strong></p>
  
  <pre><code>ID Name
  -------
  1  A
  1  B
  1  C 
  2  D 
  2  E
  3  F
  </code></pre>
  
  <p>I want to write a query in SQL Server 2008 which will return </p>
  
  <pre><code>ID Name
  ----------    
  1   A,B,C
  2   D,E
  3   F
  </code></pre>
  
  <p>Please someone help me to write this query.</p>