/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

10 votes139 views6 answers
Sql between
SQL
0 vote129 views1 answer
Delete record by id sql
SQL
0 vote138 views1 answer
Select new table sql
SQL
0 vote125 views1 answer
Mysql set variable to today's date
SQL
1 vote125 views1 answer
Where database run
SQL
16 votes113 views1 answer
Mysql reset auto increment value
SQL
3 votes151 views2 answers
How to list columns for particular tables in postgresql
SQL
1 vote147 views1 answer
Oracle plan hash value
SQL
0 vote125 views1 answer
Create synonym for dblink in oracle
SQL
0 vote125 views1 answer
Backup and restore of sqlite database from c# -sqlserver
SQL