title: TSQL First Non-Null value in Audit Table
body: <p>I have a table in SQL Server 2014 that has the following data: </p>
  
  <pre><code>ID  ChangeDate               FName   MName  LName   Revision
  1   2016-01-03 00:00:00.000  Ed      NULL   NULL    3
  1   2016-01-02 00:00:00.000  NULL    David  NULL    2
  1   2016-01-01 00:00:00.000  Joe     NULL   NULL    1   
  2   2016-01-03 00:00:00.000  Michael NULL   NULL    2
  2   2016-01-02 00:00:00.000  Henry   Jake   Smith   1
  </code></pre>
  
  <p>I need a tsql query that generates a single row with the most current output for each column: </p>
  
  <pre><code>ID FName    MName   LName
  1  Ed       David   NULL 
  2  Michael  Jake    Smith
  </code></pre>