/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

5 votes148 views1 answer
Mysql count newlines in field
SQL
0 vote140 views1 answer
Mysql count with two joins
SQL
10 votes151 views2 answers
What is database
SQL
0 vote147 views1 answer
Check for directory in bash
SQL
0 vote147 views3 answers
How to assign custom id in mysql
SQL
27 votes155 views6 answers
Set password mysql
SQL
0 vote141 views1 answer
Mysql foreach insert
SQL
1 vote124 views1 answer
How to delete data from sql database in android
SQL
0 vote147 views2 answers
Create-toys-table-with-toy_name-column
SQL
0 vote145 views1 answer
Oracle running queries sql
SQL