How to create a calendar table in SQL Server
I wanted a calendar table in SQL Server (Azure SQL Database), so here is a memo on how to create one. I googled, and it seems to be created by creating a table with "WITH" and then making a recursive call from "UNION ALL" in the table definition. WITH _calendar AS ( SELECT CAST(N'2019-01-01' AS DAT…
