Skip to content

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.

License

Notifications You must be signed in to change notification settings

mikeozero/DimDate-Table

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

9 Commits
 
 
 
 
 
 
 
 

Repository files navigation

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

image

Step 1: exec usp_CreateDimDate @year=2021

Step 2: select * from DimDate

image

Validation website

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

About

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.

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages