/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 vote196 views1 answer
Backup a table in sql
SQL
0 vote235 views1 answer
Sql server delete records with specific date
SQL
0 vote211 views1 answer
Mysql change innodb to myisam
SQL
1 vote209 views1 answer
Complete output (15 lines): /bin/sh: 1: mysql_config: not found /bin/sh: 1: mariadb_config: not found /bin/sh: 1: mysql_config: not found Traceback (most recent call last): File "<string>", line 1, in <module> File "/tmp/pi
SQL
0 vote215 views1 answer
Mysql not defined
SQL
0 vote196 views1 answer
PDOException: SQLSTATE[HY093]: Invalid parameter numb
SQL
16 votes286 views6 answers
Mysql find duplicates in same table
SQL
0 vote242 views1 answer
How to check oracle index table
SQL
0 vote201 views1 answer
Mysql Selected All Duplicate Rows
SQL
0 vote202 views1 answer
Mysql find db contarint
SQL