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

Can I just point out how much I love this site because of things like the main article in today's newsletter...

And here's a link of interest if you haven't...

I remember the one time it snowed in South Carolina when I lived there. Only about 2 inches. Nobody, and I mean NOBODY, on the road as I drove to...

We don't turn off our AC until about mid-December and then it's back on by the end of February. Our attic traps a lot of heat.