So there are 8 section of the field I need to parse

I found that this(below) "Sort of" works

Except I am getting the error "Invalid length parameter passed to the LEFT...

Thanks worked great and I learned something new today 🙂

CASE WHEN charindex('@T_750_finalscorestatus = "Draft"', Assessment_data) > 0 THEN 'Draft'

...

Wow Sean, and I tried real hard on this one... LOL 😀

I guess size really doesn't matter..

what I need are the 5 characters following the string...

Hi Sean

Thanks for the info, it does what I need, but I HATE the idea that I don't know how to do it

I guess I have a bit of reading....

Thanks...

it did.. thank you

But it gave me all the OIDS for the client and not just the most recent

Thanks Again

Thanks for the info..

Sorry Im not in here all the time and although I'm sure its not tough just not sure how to create the ddl

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...

sorry for the confusion...

SO this code

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) < { fn NOW() } - 80)

ORDER BY rsh.Client_ID,...

so this gives me the Client ID and the max Starttime for the client id using now()-80

what I'd like to add is the RS.OID for that MAX Starttime

Hi Sean

Thanks for the info

Sorry having a hard time with grouping...

but after looking at yours I did come up with this which giving me the records I need (I...

I think I need something like this

But I really have my where clause screwed up !!!

sELECT distinct dbo.RECORDED_SERVICE.OID, MAX(dbo.RECORDED_SERVICE.STARTTIME) AS Expr1, dbo.SERVICE_ITEM.SERVICE_ITEM_DESCRIPTION, dbo.CostCenter.AbbrName,

...

Thanks for the info

But I think I have explained this wrong...

I need clients that their last record on the recorded_Service table is today - 80

if anyone has any examples...

Thanks for the info

here is what I Have

DO I need a group by ?

SELECT D.*

FROM (

SELECT C.Client_ID

, MAX(r.starttime) AS LastServiceDate

from RECORDED_SERVICE r INNER JOIN

...

Sorry for not getting back I've been under the weather ..

I apprecate the help with this..

This is what I have come up with but I dont think it will...

Not sure if this helps using another example,

I receive an error on this but it may explain what I need a bit better

SELECT lname

FROM ...