Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Create Table Gutowski.DIM_TIME(
- OrderDate int,
- Rok int,
- Miesiac varchar(20),
- DzienTyg varchar(20),
- Dzien varchar(20),
- Primary Key(OrderDate)
- )
- CREATE TABLE Gutowski.MONTHS(
- "Number" int,
- "Month" nvarchar(20)
- )
- Insert into Gutowski.MONTHS
- Values (1, 'styczeń'),
- (2, 'luty'),
- (3, 'marzec'),
- (4, 'kwiecień'),
- (5, 'maj'),
- (6, 'czerwiec'),
- (7, 'lipiec'),
- (8, 'sierpień'),
- (9, 'wrzesień'),
- (10, 'październik'),
- (11, 'listopad'),
- (12, 'grudzień');
- Create Table Gutowski.DAYS_NAME(
- "Number" int,
- "Day" nvarchar(20)
- )
- Insert into Gutowski.DAYS_NAME
- Values (2,'poniedziałek'),
- (3, 'wtorek'),
- (4, 'środa'),
- (5, 'czwartek'),
- (6, 'piątek'),
- (7, 'sobota'),
- (1, 'niedziela');
- Insert into Gutowski.DIM_TIME
- Select Distinct OrderDate,
- OrderDate/10000,
- (Select Gutowski.MONTHS.[Month] From Gutowski.MONTHS Where Gutowski.MONTHS.Number = ((OrderDate % 10000) / 100)),
- (Select Gutowski.DAYS_NAME.[Day] From Gutowski.DAYS_NAME Where Gutowski.DAYS_NAME.Number = DATEPART(dw,
- CAST((OrderDate/10000) AS VARCHAR(4)) +
- RIGHT('0' + CAST(((OrderDate % 10000) / 100) AS VARCHAR(2)), 2) +
- RIGHT('0' + CAST((OrderDate % 100) AS VARCHAR(2)), 2))),
- (OrderDate % 100)
- From Gutowski.FACT_SALES;
- drop table Gutowski.DAYS_NAME;
- drop table Gutowski.MONTHS;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement