Thanks for the info...

SELECT

rsh.Client_ID, MAX(rs.STARTTIME) AS MaxDate

FROM RECORDED_SERVICE rs

INNER JOIN Recorded_Service_Helper rsh ON rs.OID = rsh.Recorded_Service_OID

GROUP BY rsh.Client_ID

HAVING(MAX(rs.STARTTIME) < (GETDATE() - 80))

ORDER BY rsh.Client_ID, MaxDate DESC

so the above gets what I need, which is the by client id the rs.starttime having a max date of today - 80

The output looks like

Client ID Max Date

002 2011-10-14 16:25:00.000

etc....

What I'd like to add is the field rs.OID the goes along with the rs.starttime(Max Date)

Does that make any more sense?

Thanks