/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

22 votes305 views4 answers
Tsql rename table
SQL
1 vote201 views1 answer
Select not matching data from two tables
SQL
0 vote190 views1 answer
Call to undefined function mysql_query() in D:\xampp\htdocs\image\index.php:11 Stack trace: #0 {main} thrown in site:stackoverflow.com
SQL
0 vote191 views1 answer
Postgres float to int
SQL
0 vote166 views1 answer
Online sql compiler
SQL
9 votes188 views2 answers
Mysql change value
SQL
7 votes243 views1 answer
Alter sequence set current value oracle
SQL
13 votes278 views3 answers
Sql select from multiple tables without join
SQL
0 vote205 views1 answer
Query only first letter string
SQL
0 vote270 views1 answer
Mysql disable triggers
SQL