title: sql select from multiple records only the most recent
body: <p>i have a table named customer_age that loks like this:</p>
  
  <pre><code>ID     1   2    3     4     5    6     7     8     9
  
  NAME  JIM  JIM  JIM  NICK  NICK  NICK  Paul  Paul  Paul                                       
  VALUE  20  13   12    10    20    8     4     24    14  
  </code></pre>
  
  <p>and i want to display only the first record from each name. Something like this</p>
  
  <pre><code>ID     1     4      7    
  
  NAME  JIM  NICK   Paul                                  
  VALUE  20   10      4    
  </code></pre>
  
  <p>So far i have not been able to work it out. 
  i use sql server 2005
  Any help would be appreciated...</p>