Date dimension view / Holiday calendar

  • 27 June 2020
  • 1 reply
  • 86 views

  • Thinkwise Local Partner Brasil
  • 14 replies

Goal

I cannot think of one business application that can go without a descend date dimension view or holiday calendar. This should be the default.

 

Solution

Below a link to a very good one, you only need to set it up once, but it's like a swiss-army knife for dates. 

https://www.mssqltips.com/sqlservertip/4054/creating-a-date-dimension-or-calendar-table-in-sql-server/


1 reply

Userlevel 6
Badge +9

There's one on our community too: 

 

Reply