Here is my last shot in the dark. This may or may not produce the results you are looking for.
with MySortedRows as
(
SELECT
rsh.Client_ID,
rs.STARTTIME,
rs.OID,
ROW_NUMBER() over (Partition by rsh.ClientID order by rs.StartTime desc) as RowNum
FROM RECORDED_SERVICE rs
INNER JOIN Recorded_Service_Helper rsh ON rs.OID = rsh.Recorded_Service_OID
where rs.STARTTIME < DATEADD(dd, DATEDIFF(dd, 0, GETDATE()), -80)
)
select *
from MySortedRows
where RowNum = 1
ORDER BY Client_ID
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/