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

It occurs to me that no matter what way I go, all of these solutions will need to be put in a CTE since I'm joining to multiple tables (not...

Thanks. I'll check those out... I didn't even think about CROSS APPLY. I keep forgetting about that.