Report question

Question: SQL server select distinct rows using most recent value only