BTW... the way to get the code to display without all the extra blank lines in it is to copy'n'paste the code into NOTEPAD first.  Then, copy'n'paste from NOTEPAD to...

Heh.... lordy.  I just reread BOL for PERCENTILE_DISC ("disc" means "discrete").. It INTENTIONALLY works the way your tests came out.  Here's the description found at the official MS documentation at...

Yowch.  That's just not right.  Thank you very much for testing.  I should be able to...

Ah... I think I found it.  From BOL...

To be honest, I actually prefer Paritioned Views over Partitioned Tables.  Try restoring just 3 months of a Partitioned Table to another server sometime and you'll
see what I...

So, in reference to your original question of...

...what is your conclusion?

For more info on DATEPART, please see the article at the following link.
https://docs.microsoft.com/en-us/sql/t-sql/functions/datepart-transact-sql?view=sql-server-2017

There's also a wealth of knowledge just a click away in the menu...

Why wouldn't you use an INSERT/SELECT into a table and create the email from those results?

I'm not an Azure user by any means so be gentle, please... Azure doesn't have a BULK INSERT command or OPENROWSET? :blink: