/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

24 votes267 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
SQL
0 vote292 views1 answer
How many columns can be used for creating index?
SQL
-2 votes339 views1 answer
How-to-remove-mysql-root-password
SQL
11 votes326 views5 answers
Sql server reset identity
SQL
2 votes322 views2 answers
How to import large sql file in phpmyadmin in ubuntu
SQL
0 vote329 views1 answer
How to check which table has data in mysql
SQL
0 vote336 views1 answer
Sql server Cost Fifo query
SQL
0 vote295 views1 answer
Drop check command
SQL
1 vote367 views1 answer
Hangfire clear all jobs
SQL
0 vote360 views1 answer
How to check rollback status in oracle
SQL