title: How to coalesce many rows into one?
body: <p>I am using SSMS 2008 R2 and am simply trying to coalesce many rows into one.  This should be simple I think, but it is currently repeating data in each row.  Consider:</p>
  
  <pre><code>create table test
  (
  Name varchar(30)
  )
  insert test values('A'),('B'),('C')
  select * from test
  
  select distinct Name, coalesce(Name + ', ', '')
  from test 
  </code></pre>
  
  <p>How can I rewrite this to achieve one row like:
  A,B,C</p>