>>This should get you started
>>

>>SELECT * FROM ChildTable ct WHERE NOT EXISTS (SELECT 1 FROM ChildTable WHERE pk = ct.pk and SomeDate > ct.SomeDate)
>>

>
>Thanks, but this returns all records from the child table.

If you want to fix this code, Sergey meant here:


>>

SELECT * FROM ChildTable ct WHERE NOT EXISTS (SELECT 1 FROM ChildTable WHERE FK = ct.FK and SomeDate > ct.SomeDate)

use the field you need to aggregate on here to join, e.g. ClientID in your case.

Or, similar variation:

select * from ChildTable where PK = (select top 1 PK from ChildTable order by ModDate DESC)