Date Table
http://www.sqlservercentral.com/articles/T-SQL/76599/
create view [dbo].[Calendar] as with Dates as ( select cast(’2010-01-01′ as date) as CalendarDate union all select dateadd(day , 1, CalendarDate) AS CalendarDate from Dates where dateadd (day, 1, CalendarDate)<= dateadd(year,
... [read more]
Submit a review:
Login required.