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.

And yes, I just womansplained how to change a car battery. Feels good to be the one doing the "splaining" for once. @=)

And here's AMD's response to the whole thing: https://www.amd.com/en/corporate/speculative-execution