/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

1 vote185 views2 answers
Sql groub by count
SQL
0 vote252 views1 answer
Sqlite update where exists
SQL
2 votes232 views4 answers
Mysql select into new table
SQL
3 votes181 views2 answers
Oracle sql drop sequence
SQL
2 votes181 views1 answer
How to delete view in sql
SQL
0 vote263 views1 answer
How to login to mysql in homestead
SQL
5 votes183 views1 answer
Oracle ora-00054 causes
SQL
0 vote192 views1 answer
Oracle merge insert if not exists
SQL
16 votes192 views6 answers
This is incompatible with sql_mode=only_full_group_by
SQL
150 votes534 views10 answers
Grepper
SQL