/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

3 votes246 views2 answers
Monthname sql
SQL
13 votes221 views2 answers
Display users in mysql
SQL
1 vote235 views1 answer
Import mysql dump database command line linux
SQL
3 votes226 views2 answers
Mysql time
SQL
0 vote243 views1 answer
Mysql DDL
SQL
11 votes255 views2 answers
Having clause in sql
SQL
14 votes236 views3 answers
SQL trim
SQL
2 votes285 views1 answer
How to check if a row is null in sql
SQL
0 vote255 views1 answer
Radius search with point data in mysql
SQL
0 vote295 views1 answer
Redshift running queries
SQL