/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

4 votes352 views1 answer
SQL find text in SP
SQL
0 vote383 views1 answer
How to get one year old query from plan cache
SQL
0 vote347 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL
3 votes356 views2 answers
Get current year sql
SQL
0 vote334 views2 answers
Mysql multiply
SQL
0 vote351 views1 answer
Oracle allow space to user
SQL
0 vote341 views1 answer
Add plugins to mysql workbench
SQL
1 vote372 views1 answer
How to remove identity from a column in sql server
SQL
1 vote364 views1 answer
Found option without preceding group in config file: /etc/mysql/mariadb.conf.d/50-server.cnf at line: 1
SQL
0 vote371 views1 answer
Groupby sort sql hive
SQL