title: Combine multiple rows into one
body: <p>I have data that looks like this;</p>
  
  <pre><code>Id  Name        Number  Birthdate   
  0   Dajit Singh NULL    6/9/2007  
  5   Dajit Singh 12345   NULL   
  11  Dajit Singh NULL    NULL
  </code></pre>
  
  <p>I want to progammatically combine these rows into 1 row with all data available:</p>
  
  <pre><code>0   Dajit Singh 12345   6/9/2007
  </code></pre>
  
  <p>Here's what I've got so far, but it doesn't do it:</p>
  
  <pre><code>Select Id, 
         Max(Name)   As Name, 
         Max(Number)    As Number, 
         Max(Birthdate) As Birthdate 
  From   tblPerson 
  Group By Id, Name, Number, Birthdate
  Order By Name
  </code></pre>
  
  <p>How can this be accomplished?</p>