Sadly that requires more time than I have readily available to sanitise and remove any naming etc. that is "internal" ... which in turn...

maybe some analysis of what proportion of the Email Body are Small,. Medium and Big in size. Something like this

SELECTSUM(CASE WHEN LEN(Body) <= 1000 THEN 1 ELSE...

That's an average of 3.5 Pages of text (assuming Nvarchar) PER message....

You probably know this, but Paul Randal is an avid history reader and he seems to manage to get through a huge number of books each year. He publishes a...

Yes ... but my Splitter returns an Item No, and if I...

My Splitter function takes 3 parameters - data, delimiter and ValueForBlanks - typically empty string or NULL, but the value '[[DELETE]]' then completely removes any blank entries

Short of using CamelCase seems a bit non-standard to only have one "E" ... other such reserve words have "_" separator ...

I can't see how presence of existing TEMP table would cause a problem as

CREATE TABLE #ReportResults (dateStamp dateTime NOT NULL, dataInterval int)

would then fail.

longshot : But ... maybe it is...

Thanks for taking the time to type that Brain, all very informative 🙂

For 3rd party database...

ISNULL has another quirk, as well... if the 2nd operand is actually a SELECT or a function or any other type of executable, it will be executed even if...

deleted

Did you change the Compatibility Level when upgrading from SQL 2014? (e.g. from 120 to 150)

If so maybe try it back at 120 just as a test for this query?

All...

First result I found in Google :

https://www.mssqltips.com/sqlservertip/5542/using-for-xml-path-and-stringagg-to-denormalize-sql-server-data/

STRING_AGG()?  I'm really looking forward to that when we shift our boxes at work to 2017+.  That'll be one (like ROW_NUMBER(), etc) that they'll need to pry from my...

It doesn't, that's the point. More correctly "It is unheard of" rather than just "Fairly unlikely"...