SELECT EmployeeId, MAX (ReviewDate) AS MaxReviewDate FROM tbl_stuff GROUP BY EmployeeId ) t1 ON t.EmployeeId = t1.EmployeeId AND t.ReviewDate = t1.MaxReviewDate WHERE (some filters on t) </pre> ...

select top 10 would also work here, and is generally "better" than using set rowcount.<BR><BR>I think previously you were just missing the desc clause in your order by.