/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 vote112 views1 answer
Incorrect string value: mysql
SQL
0 vote109 views1 answer
Inserted row count tsql
SQL
3 votes114 views2 answers
Sqlite print all column names
SQL
4 votes104 views1 answer
Postgresql show current database
SQL
3 votes119 views2 answers
How to start postgresql on windows
SQL
0 vote104 views1 answer
Authentication in sql server
SQL
0 vote120 views1 answer
View to table sql
SQL
0 vote139 views1 answer
Sql server is not
SQL
0 vote158 views1 answer
Get last inserted primary key
SQL
0 vote105 views1 answer
Postgresql delete multiple rows
SQL