/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

2 votes191 views1 answer
How to find constraints on a table in oracle
SQL
1 vote179 views1 answer
Find logged in users mysql
SQL
0 vote193 views2 answers
How to save result of sqlite query in a table
SQL
2 votes192 views1 answer
Sql alchemy or
SQL
0 vote203 views1 answer
Kill a pid redshift
SQL
0 vote192 views1 answer
Sql combine results from two tables
SQL
0 vote184 views1 answer
Install mysql 8 linux
SQL
0 vote149 views1 answer
Import csv to mysql
SQL
0 vote513 views1 answer
Sql field equals multiple values
SQL
6 votes196 views1 answer
Identify primary key in oracle table
SQL