If you have just one client for whom you want to get the dataSELECT TOP (1) Client, Date, Rep
FROM Tbl t
WHERE Client = 'JaneDoe'
ORDER BY Date DESC
For all clients
SELECT Client, Date, Rep
FROM
(
SELECT *,
ROW_NUMBER() OVER (PARTITION BY Client ORDER BY Date DESC) AS RN
FROM Tbl
)s
WHERE RN = 1;
Last rep billing a client
Posted - 12/27/2012 : 09:41:22
