DIM_Calendar

[Marina-ai-hub]

DIM_Calendar.csv

SQL Code:
-- Clened DIM_DateTable --
SELECT
[DateKey]
,[FullDateAlternateKey] AS Date
--,[DayNumberOfWeek]
,[EnglishDayNameOfWeek] AS Day
--,[SpanishDayNameOfWeek]
-- ,[FrenchDayNameOfWeek]
-- ,[DayNumberOfMonth]
-- ,[DayNumberOfYear]
,[WeekNumberOfYear] AS WeekNr
, [EnglishMonthName] AS Month
, LEFT([EnglishMonthName], 3) AS MonthShort -- First three letters
--,[SpanishMonthName]
-- ,[FrenchMonthName]
,[MonthNumberOfYear] AS MonthNr
,[CalendarQuarter] AS Quarter
,[CalendarYear] AS Year
-- ,[CalendarSemester]
-- ,[FiscalQuarter]
-- ,[FiscalYear]
-- ,[FiscalSemester]
FROM
[AdventureWorksDW2022].[dbo].[DimDate]