I'll second that.  It would be mighty handy.

I've not done a deep dive on it but isn't this the same request as the following link with different test data?

https://www.sqlservercentral.com/forums/topic/make-last-week-to-zero

Here's the corrected math considering the 100,000 rows instead of the extra zero my too-quick keyboard added....

If the rest of the data follows the example of the data you provided,...

Apologies... I used 1,000,000 for the source row count instead of just 100,000.  I'll be back with corrected calculations.

This is a prelude to SPAM.  It's becoming more...

If you had the answer of "Big Brother is watching", more people might have gotten a correct answer. 😀

Keep it simple...

--===== Find all items in Prod1 that are not in Prod2
 SELECT * FROM prod1.xxx.dbo.guest
 EXCEPT
 SELECT * FROM prod2.xxx.dbo.guest 
;
--===== Find all items in...

You have 1 common StudentAccKey with 1 common StudentKey and 1 common StartDate.

And yet there are two StudentID's and six different StudentName's.

The code that you're using to get the data...

I'm very new to the sql and am wondering what is the easiest way to run the same query multiple times with different dates (ideally is the last day...

I've found that the "sweet spot" for the 32 core machine at one of the companies I do work for is a MAXDOP of 4.  Their biggest problem is the...

Awesome link and explanation, Grant.  Thank you.

The reason I'm...

I think the problem is that people doubt your claim.  Case in point...

https://www.google.com/search?q=Get+backup+status+for+multiple+sql+servers+using+powershell

Let's ask the question... how often do the "temp tables" appear?  Let's also ask, why do you have "temp tables" of such a size to begin with?

Oh lordy... I should have known.  Good luck there, Don.    And thanks for posting the original problem... this has been and continues to be a really interesting problem and, once...