title: How do I merge data from several rows in SQL Server
body: <p>Here is my situation:</p>
  
  <p>TABLE PEOPLE (code, name, + other fields that are identical for records with same code)</p>
  
  <pre><code>1;John Wayne
  2;Jack Smith
  2;Jill Smith
  3;Bill Peyton
  3;Gill Peyton
  3;Billy Peyton
  </code></pre>
  
  <p>The result I would like:</p>
  
  <p>VIEW PEOPLE (code, name, + other fields that are identical for records with same code)</p>
  
  <pre><code>1;John Wayne
  2;Jack Smith Jill Smith
  3;Bill Peyton Jill Peyton Billy Peyton
  </code></pre>
  
  <p>Can some one please help me create a view that would give me this result?
  The point is merging rows with same "code" and merge names in column "name". All the other fields are 100% identical for rows with same "code".</p>
  
  <p>Thank you.</p>