Your query contains two tables, but you've only provided one sample table.  Furthermore, the fields in your sample table do not match the fields in either of the tables in...

I don't think that you want to do this in general.  I could see doing this as part of an application, but the application would probably feed the information into...

I should also add that it's pointless to ORDER BY one of the partition expressions (in this case YearMonth).  By definition, all rows within a partition have the same exact...

I ran the following test on a SQL 2016 box and the query used an index seek, so this claim is false.

CREATE TABLE #TEST ( id...

The package is just an XML file.  In some cases, it's easier to make simple changes in the XML rather than using the GUI.  I believe that this is one...

It reminds me of ASCII art from the 80s (70s?) and it definitely works best with a fixed-width font.  I still think it's more trouble than it's worth, but here...

It shouldn't be that hard to create, but I also have to ask why.  For any kind of report that might need this, I would use reporting software where you...

A loop is definitely not necessary (and will perform badly to boot).  Have you tried the sub-query?  My first thought was a LEFT OUTER JOIN.  See if you can figure...

You should generally avoid functions/conversions on fields in ON/WHERE clauses.  You have multiple functions/conversions in your ON clause, which is why you are having problems.

Part of the issue...

I back a lot of board games on Kickstarter, and I eventually decided to get a PO Box at a UPS store for package deliveries, because too many of my...