Search
 
SCRIPT & CODE EXAMPLE
 

SQL

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 
ADD CONTENT
Topic
Content
Source link
Name
9+6 =