This post is meant partly as a “reminder to self” but also to show that, if you need to generate a list of dates, all you need are numbers. Oh well, if that doesn’t make sense: read on!
One of the undocumented tables of SQL Server is called spt_values and it is located in the master [...]
Click here to see the original post