Part one of two, so that I can put the topics on the menu in different places.
Today's topic is creating a date calendar in SQL to use in reports. I'll show the importance of this in the next post, for now, just the practical code.
Creating a date dimension or calendar table in SQL Server (mssqltips.com)
I've copied the code below with only minor edits from the link above.
The output will look like this. This is only about half the columns, though, it's way too wide to show here.
