Sql

Search

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

Comment

PREVIOUS	NEXT

Code Example
Sql :: modify xml in sql server
Sql :: sql null functions
Sql :: java hide mysql login credentials
Sql :: low level operator in dbms
Sql :: sql query wordpress export post
Sql :: get last 3 years data in mysql
Sql :: pl sql package body
Sql :: postgresql GRANT role_2 TO role_1
Sql :: redshift alter table alter column set not null
Sql :: valadate mysql
Sql :: update or delete on table "model" violates foreign key constraint
Sql :: transaction in java mysql
Sql :: intellij idea add mysql connector
Sql :: sqlite display data in separated columns
Sql :: sp help text in postgresql
Sql :: create query in where clasue
Sql :: check records older than 10 days
Sql :: sum values by month mariadb
Sql :: mysql select max and corresponding row
Sql :: get id if is not equal in certain table
Sql :: Pattern Sql Rlike same as REGEXP
Sql :: insert into database items linq2sql
Sql :: select a row include list of array with join table SQL
Sql :: can you create views in dbbrowser
Sql :: oracle chain step succeeded
Sql :: list foreign user mapping postgres
Sql :: mysql master slave setup with keepalived
Sql :: oarcale list objects
Sql :: drop check command
Sql :: normalization in database 2nd normal form

Search

SQL

kimball data warehouse sql calendar

ADD CONTENT