title: Combining rows in SQL Server
body: <p>I'm trying to combine rows in SQL Server.</p>
  
  <p>Assume I have a table like:</p>
  
  <pre><code>  C1 |  C2  | C3
    1  |  A   | 
    1  |      | 
    1  |      |  B
    2  |  A   |  
    2  |      |  C
  </code></pre>
  
  <p>And I want to end up with:</p>
  
  <pre><code>  C1 |  C2  | C3
    1  |  A   |  B
    2  |  A   |  C
  </code></pre>
  
  <p>Any way I can do this with one query?</p>
  
  <p>At the moment I'm parsing the data manually with c#, but it's slow, and I can't limit the number of rows that are returned easily.</p>
  
  <p>Thanks in advance!</p>