title: Concatenate column values for rows with the same values (of different columns)
body: <p>SQL Server 2005</p>
  
  <p>I have a table which returns</p>
  
  <pre><code>ID  name    prop    value
  --------------------------
  1   one     Prop1   a
  1   one     Prop1   b
  1   one     Prop2   c
  2   two     Prop1   d
  2   two     Prop2   e
  </code></pre>
  
  <p>How can I run a select on it to return</p>
  
  <pre><code>ID  name    prop        value
  -----------------------------
  1   one     Prop1       a,b
  1   one     Prop2       c
  2   two     Prop1       d
  2   two     Prop2       e
  </code></pre>