/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 vote116 views1 answer
Pagination with row_number
SQL
0 vote120 views1 answer
Mysql events not work
SQL
0 vote275 views1 answer
Current month transactions in mysql
SQL
0 vote106 views1 answer
What are the aggregate function in sql
SQL
7 votes116 views2 answers
Mysql db size
SQL
0 vote115 views1 answer
Mariadb cast null to 0
SQL
0 vote125 views1 answer
Django mysqlclient connection string
SQL
10 votes109 views2 answers
Linux command line import mysql database
SQL
-2 votes169 views1 answer
Trunc in sql
SQL
17 votes144 views6 answers
Sql current date
SQL