What is used for SYS Calender in sql sever

Database

What is used for SYS Calender in sql sever

There is a syscalender function in teradata from where we can populate the time dimension. Is there any function in Sql server which is same like syscalender in teradata.
1 REPLY
Enthusiast

Re: What is used for SYS Calender in sql sever

There are two options,
1. Use a view with lots of data functions (you won't be able to get everything that TD has easily).
2. Create your own. It is pretty easy with using Excel to generate the data. I went this route and created 30 years (15 back, 15 forward).
It is surprising that SQL Server doesn't have this. I have found it to be very useful.

R