title: Multiple rows in single field separated by commas SQL Server
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/451415/simulating-group-concat-mysql-function-in-ms-sql-server-2005">Simulating group_concat MySQL function in MS SQL Server 2005?</a>  </p>
  </blockquote>
  
  
  
  <p>What will be the SQL Server code to achieve this result:</p>
  
  <pre><code>SO number  Line number            
  123           6
  123          189
  456           34
  </code></pre>
  
  <p>Output required:</p>
  
  <pre><code>SO number  Line number 
   123            6,189
   456               34   
  </code></pre>