Great article, and an excellent technique I've been utilising (with care!) for a while.

I do however raise an argument against your statement that "The "Quirky Update" will work just fine...

So now we've tracked it down to a slow call to the cluster DTC service running the "Get Address" eventsubclass

this is causing an error on the client of "eventid=TRANSACTION_PROPOGATION_FAILED_CONNECTION_DOWN_FROM_REMOTE_TM"

We can...

Told you there was a more efficient way of doing it 🙂

probably more efficient ways, but this would do it:

DECLARE @Months TABLE (MonthYear VARCHAR(20))

DECLARE @DATE DATETIME

SELECT @DATE = CONVERT(VARCHAR, @FromDate, 106)

WHILE @DATE < @ToDate

BEGIN

INSERT @Months SELECT...

We have US and UK offices, and often encountered this problem with one user getting one result and another a different one for the same "DATEPART(dw" statement (as the DATEFIRST...