DimDate Table

A T-SQL Stored Procedure to generate a Date Table. Just input a year and a week start date, it will show that year's calendar with workdays flag, week information and Ontario's Public Holidays.

select * from @ontarioholiday

Step 1: exec usp_CreateDimDate @year=2021

Step 2: select * from DimDate

Validation website

https://canada-holidays.ca/provinces/ON