Man, I am gone for a few years and this thread is still going.  Glad to see so many names my faulty memory remembers.

Your query does not join table 1 and table 2. How are 1 and 2 related?

I might suggest for readability creating a variable to hold max date prior to the...

Thanks! it is the simple things.

Thanks, Lowell.  That is exactly the information I was looking for, plus more.
Brandie, for some reason my COBRA goes for only 13 months.

Thanks again,
djj

Well, still looking for a job.  However, got an email asking if I would do some hourly training.  This is from a co-worker that got laid off at the same...

Thank you everyone for your insights and comments.  I would list you but I might miss someone. 😀

I do try and let everyone know my strengths and weaknesses...

Well I have been out of a job for a few weeks now, and I must say reading this thread does not show recruiters in a good light.  I have...