title: How to stuff duplicate records in 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><br>
    <a href="https://stackoverflow.com/questions/7896239/sql-query-for-aggregation-concatenation">SQL Query for aggregation/concatenation</a>  </p>
  </blockquote>
  
  
  
  <p>I am trying to use the stuff function in SQL server to stuff certain info. Here is the example:</p>
  
  <pre><code>Money     Age    Gender
  860       9          F
  860       15         M
  860       15         M
  860       16         M
  860       16         F
  </code></pre>
  
  <p>I would like to stuff the Age and Gender column so that only one record will display as following:</p>
  
  <pre><code>Money   Age                 Gender
  860     9, 15, 15, 16, 16   F, M, M, M, F
  </code></pre>
  
  <p>Please note, I would like to keep the two 15s and three M in the Age and Gender respectively.</p>