I think it would be nice to archive off the older SQL version forums so the threads are still available even if the posting ability is not.

I...

Hola, Fellow Threadzians.

As I push my head above dense project waters to grab a breath of fresh air, I was wondering if anyone would care to assist me...

I probably shouldn't have used the word "upgraded." I did get a new box entirely, fresh install of the OS.

Sorry for the length of time to respond to...

The worst part about it is the people who were developing this code kept insisting on turning SQL tables into flat files and doing stupid stuff like that, no matter...

Thanks, Drew. I was working on that, but changing different items in the CASE. I'll take a look at that and see how it works.

BAH. I thought I was through with this, but I just found an outlier.

When testing with the this data:

INSERT INTO #MyTemp (Office, POID, DeliverySite,...

Drew, thank you so very much. I'd never heard of LAG() or the ROWS UNBOUNDED PRECEDING stuff until now. I love this job because I learn new things every day.

Had to fiddle with your code, Drew. It didn't take into account multiple Address codes on a single invoice. Then again, neither did my sample data because I didn't see...

Almost 3 hours later and the CTE is still trying to run. I'm going to yank it out, run the code for PayDate = LastAccountDate, then do an update for...