I have to think that if you're generating scripts that are multiple GB's something else can be improved other than just finding a way to actually run them.

On a side note is there some particular reason that the EU is doing this?  Or is just an overly paranoid idea?

Is there any reason not to just use sp_rename to do this?  Keep both copies of the table similar to what Jeff is suggestng but instead of a view and...

Is there a 1 to 1 match between both tables?  Check the row count you get from the select vs how many records get updated.

Hmm.... everything I've seen says that threadrippers are performing pretty much on par with intel core for core and are certainly more affordable.  The biggest drawback seems to be heat...

All that LastDayOfExemptPayPeriod column seems to calculate is the last day of the month so it'll change every day on the first of the month.  In which case wouldn't that calculation...