CREATE PROCEDURE CreateTime AS
declare @ss as datetime
declare @ss2 as datetime

set nocount on

CREATE TABLE [DimensionTime] (
		[Day_Id] [datetime] NOT NULL ,
		[Day_Name] [char] ( 10 ) COLLATE Cyrillic_General_CI_AS NOT NULL ,
		[Wk_Id] [int] NOT NULL ,
		[Wk_Num] [int] NOT NULL ,
		[Wk_Name] [char] ( 10 ) COLLATE Cyrillic_General_CI_AS NOT NULL ,
		[Mtd_Id] [int] NOT NULL ,
		[Mtd_Num] [int] NOT NULL ,
		[Mtd_Name] [char] ( 10 ) COLLATE Cyrillic_General_CI_AS NOT NULL ,
		[Mtd_FullName] [char] ( 10 ) COLLATE Cyrillic_General_CI_AS NOT NULL ,
		[Qrt_Id] [int] NOT NULL ,
		[Qrt_Name] [char] ( 10 ) COLLATE Cyrillic_General_CI_AS NOT NULL ,
		[Year_Name] [int] NOT NULL ,
		[DayOfWeek_Num] [int] NOT NULL ,
		[DayOfWeek_Name] [char] ( 20 ) COLLATE Cyrillic_General_CI_AS NOT NULL ,
		CONSTRAINT [PK_DimensionTime] PRIMARY KEY  CLUSTERED 
		([Day_Id])  ON [PRIMARY] ) ON [PRIMARY]


set language 'русский'

set @ss = '01.01.03'
set @ss2 = '01.01.06'

while @ss<>@ss2
begin

INSERT INTO dbo.DimensionTime (Year_Name, Qrt_Id,Qrt_Name,Mtd_Id,Mtd_Num,Mtd_Name,Mtd_FullName,Wk_Id,Wk_Num,Wk_Name,Day_Id,Day_Name,DayOfWeek_Num,DayOfWeek_Name)
VALUES(
	Year(@ss),
	convert(Char( 4 ),Year(@ss)) + convert(Char( 1 ),DatePart(quarter,@ss)),
	'Q' + convert(CHAR( 1 ), DatePart(quarter,@ss))+', '+convert(CHAR,Year(@ss)),
	
	(CASE WHEN Month(@ss)< 10  THEN 
		CONVERT(Char( 4 ),Year(@ss))+'0'+Convert(Char( 2 ),Month(@ss))
		ELSE CONVERT(Char( 4 ),Year(@ss))+Convert(Char( 2 ),Month(@ss)) END),
	
	Month(@ss),
	Left(datename(month,@ss), 3 )+', '+convert(CHAR,Year(@ss)),
	datename(month,@ss),
	
	(CASE WHEN datename(week,@ss)< 10  THEN
		CONVERT(Char( 4 ),Year(@ss))+'0'+Convert(Char( 2 ),datename(week,@ss))
		ELSE CONVERT(Char( 4 ),Year(@ss))+Convert(Char( 2 ),datename(week,@ss)) END),
	
	datepart(week,@ss),
	(CASE WHEN datepart(week,@ss)< 10  THEN 
		'Нд0'+Convert(Char( 1 ),datepart(week,@ss))+', '+Convert(Char( 4 ),Year(@ss))
		ELSE 'Нд'+Convert(Char( 2 ),datepart(week,@ss))+', '+Convert(Char( 4 ),Year(@ss)) END),
	@ss,
	
	CASE WHEN Day(@ss)< 10  THEN 
		'0'+Convert(Char( 1 ),Day(@ss))
		ELSE Convert(Char( 2 ),Day(@ss)) END
		+'-'+Left(datename(month,@ss), 3 )+'-'+Right(convert(CHAR( 4 ),Year(@ss)), 2 ),
	
	datePart(weekday,@ss),	
	datename(weekday,@ss)
)

set @ss=@ss+ 1 
end
GO