Thank you gentlemen.

Do I have this wrong? if a baseDate of 1/1/2006 at 07:00 represents the beginning of Shift A, then the shift date of 12/31/2005 at 06:00 represents shift B....

thank you.

excellent. thank you. so it appears that I should use type string and validate using regular expression as I just can't get non string data types to allow...

Thanks everyone for taking the time and offering your expertise. I wasn't sure how much to post in the forum since the stored procedure that this comes from is...

I now have learned what WITH does and ROW NUMBER. On a quest to figure out OVER and PARTITION.

I am now trying to apply the suggested solution...

Thanks. It looks like it does exactly what I need. I would like to learn more about how this works. Got any good reference sources to recommend?

Based on running this query for the last two months worth of data, after applying the proper filtering, it would seem that you have solved the issue for me. ...

cool cool cool. upon first run on the test data when filtered for the corerct exit month, it looks like it did it. I'll let you know if...

Thank you sir for a working example. This gets me closer.

The requirement is I need to take a look at clients who have exited a particular social...

Could some one provide me with an example?

Thanks for all the input thankfully it is unlikely that I'll need to iterate thousands of records since I will be running this report once a month and only be...

Using cross apply and changing the outer join to inner got me very close. The problem is that the results are excluding clientid 1. I believe this is...

Thank you very much for the work put into this. It is close to what I need, and I will see if I can work out how to get...

Thanks for the quick reply. It does indeed cascade. And I would like an example to build upon if possible.