title: SQL 2005 Merge / concatenate multiple rows to one column
body: <p>We have a bit of a SQL quandry. Say I have a results that look like this... </p>
  
  <p>61E77D90-D53D-4E2E-A09E-9D6F012EB59C | A <br />
  61E77D90-D53D-4E2E-A09E-9D6F012EB59C | B <br />
  61E77D90-D53D-4E2E-A09E-9D6F012EB59C | C <br />
  61E77D90-D53D-4E2E-A09E-9D6F012EB59C | D <br />
  7ce953ca-a55b-4c55-a52c-9d6f012ea903 | E <br />
  7ce953ca-a55b-4c55-a52c-9d6f012ea903 | F <br /></p>
  
  <p>is there a way I can group these results within SQL to return as </p>
  
  <p>61E77D90-D53D-4E2E-A09E-9D6F012EB59C | A B C D  <br />
  7ce953ca-a55b-4c55-a52c-9d6f012ea903 | E F  <br /></p>
  
  <p>Any ideas people? </p>
  
  <p>Many thanks </p>
  
  <p>Dave </p>