I actually just realised PIVOT isn't working when Multiple rows are present  Putting a fake aggregation such as MAX isn't working as expected.

I'm stumped 🙁

Any ideas, to point me...

Same to you and yours, Steve.  And Merry Christmas to everyone.  This is a well deserved 4 day weekend for me.  Next weekend is, as well.

Update.  We migrated from 2016 Enterprise Edition to 2022 Enterprise Edition.  Virtually everything is run 30-40% slower.  I also did some simple tests between 2017 and 2022 on the same...

The following isn't dependent on DATEFIRST at all.

DECLARE @AnyYear INT = 2023;
 SELECT  ThanksGiving = v1.TG
        ,BlackFriday  =...

I agree... for the OP, I've not had to work with Linux nor containers.

Hopefully, this will be a nice "bump" to get someone that has to take a look at...

Yep.  Understood.  All I'm saying is that too many people think that xp_CmdShell isn't...

TruDat!

To...

xp_cmdshell is easy to abuse so I use it sparingly.

I also find that any time I am looking to use xp_cmdshell, it is likely because I am trying to...

Just saw this one pop up, not sure if it is a "known" bug or not, but thought I'd report it as I didn't see it in this section.

If...

Thank you all for the help!  Phil's suggestion worked for me, I was trying to avoid it as there is no leading index on the date columns.

I as well...

I can't help with SSRS but I'm still trying to figure out why anyone would want to remove facts that matter from an aggregate.  This appears to be a "only...

As a bit of a sidebar, this is why people need to make sure they have normalized data in their tables instead of "convenient" data.  Table 2 needs to be...

Heh... lordy.  OK... Two more reasons why I'm glad I don't have to deal with Azure.  "Trapped Short Rows" can relatively large decreases in performance.  Now I see why you...

Well the flip side of that question is, if you're passing the information on to a system that wants to read JSON do you store the sqlified...

This site has had the problem of not posting the 1st post on subsequent pages until an additional post is made for...