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

ID FName    MName   LName
1  Ed       David   NULL
2  Michael  Jake    Smith