/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
Mysqli_real_connect(): (28000/1045): Access denied for user 'u0738423'@'www8.aname.net' (using password: YES)
SQL
19 votes193 views5 answers
Date between in mysql
SQL
0 vote283 views1 answer
Database timezone
SQL
1 vote192 views1 answer
Ubuntu mysql cannot connect to database server remote
SQL
3 votes191 views1 answer
Sql print all names that start with a given letter
SQL
-1 vote196 views3 answers
How to restart mysql in linux
SQL
2 votes204 views1 answer
How to show the whole table in sql
SQL
0 vote250 views1 answer
Fetching data from mysqldb
SQL
13 votes178 views4 answers
GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
8 votes178 views1 answer
How to remove tables from postgresql
SQL