SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Joshua A. Walker / sql script to populate time dimension / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 21:15:00 GMT20RE: sql script to populate time dimensionhttp://www.sqlservercentral.com/Forums/Topic1044327-1476-1.aspxhttp://www.sqlservercentral.com/scripts/Data+Warehousing/62844/Wed, 11 Jan 2012 08:20:08 GMTdaryl.ball-1031223sql script to populate time dimensionhttp://www.sqlservercentral.com/Forums/Topic1044327-1476-1.aspxHiI have created a time dimension with the following fieldsSELECT TOP 1000 [EventDate] ,[Day] ,[Month] ,[Year] ,[DayName] ,[MonthName] ,[DayOfWeek]-----Day of a week starting on sunday ,[DayOfWeek_MTWTFSS]---Normal day of a week starting on monday ,[WeekOfYear] ,[WeekOfYear_MTWTFSS]---Normal week of the year ,[ExchangeRate]---constant as 1350.0000 ,[LastDayOfMonth] FROM [ETL].[dbo].[Dates3]I want to create sql script or statement thal can assist me to populate the records in this dimension for the whole year. Please helpFri, 07 Jan 2011 05:43:50 GMTsalizajr