Hi
I have created a time dimension with the following fields
SELECT 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 help