/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

0 vote188 views1 answer
Sql waitfor
SQL
-1 vote178 views3 answers
How to restart mysql in linux
SQL
0 vote178 views1 answer
SQL: calculate hours from two dates
SQL
2 votes215 views1 answer
Tcl in sql
SQL
13 votes165 views4 answers
Mysql select last 10 rows
SQL
1 vote166 views3 answers
How to get date in sql
SQL
0 vote206 views1 answer
Trigger stock phpmyadmin
SQL
22 votes219 views4 answers
Date format mysql
SQL
0 vote186 views1 answer
How to add unique key constraint in mysql
SQL
0 vote204 views1 answer
How to input data as id in database sql c#
SQL