/SQL/Kimball data warehouse sql calendar

Kimball data warehouse sql calendar

/*Add Fiscal Calendar columns into table DimDate*/

ALTER TABLE [dbo].[DimDate] ADD
	[FiscalDayOfYear] VARCHAR(3),
	[FiscalWeekOfYear] VARCHAR(3),
	[FiscalMonth] VARCHAR(2), 
	[FiscalQuarter] CHAR(1),
	[FiscalQuarterName] VARCHAR(9),
	[FiscalYear] CHAR(4),
	[FiscalYearName] CHAR(7),
	[FiscalMonthYear] CHAR(10),
	[FiscalMMYYYY] CHAR(6),
	[FiscalFirstDayOfMonth] DATE,
	[FiscalLastDayOfMonth] DATE,
	[FiscalFirstDayOfQuarter] DATE,
	[FiscalLastDayOfQuarter] DATE,
	[FiscalFirstDayOfYear] DATE,
	[FiscalLastDayOfYear] DATE
	GO

Source: codeproject.com

Similar codes

15 votes278 views2 answers
Open postgress in terminal mac
SQL
2 votes270 views1 answer
How to search table name in stored procedure in sql server
SQL
0 vote295 views1 answer
Connecting to my cloud sql server with c#
SQL
2 votes306 views1 answer
Sql string_agg
SQL
0 vote320 views1 answer
Mysql grant all on all databases
SQL
0 vote318 views1 answer
Select the date 30 days less that the todays date sql request
SQL
0 vote274 views1 answer
How to save data in database in mysql node
SQL
4 votes311 views1 answer
Sql delete multiple conditions
SQL
0 vote293 views2 answers
Update information in a mysql column
SQL
0 vote299 views1 answer
How to check which table has data in mysql
SQL