declare @int int
declare @hour int

set @int = 15 --230
set @hour = 24

while @int >= -1  -- -600
		begin
			while @hour >= 0  --<= 24 and > 0
					begin
						--insert into s_cas
						select
						left(convert(smalldatetime, getdate()- @int, 20), 11) as date
						,year(getdate()- @int) as y
						,month(getdate()- @int) as m
						,day(getdate()- @int) as d
						,datediff(week, dateadd(year, datediff(year, 0, (getdate()-@int)), 0), getdate()-@int+6) as w
						,@hour as h
						,cast(year(getdate()-@int)as nvarchar(4)) + '-' +cast(month(getdate()-@int) as nvarchar(2)) + '-' +cast(day(getdate()-@int) as nvarchar(2)) + '-' + cast(@hour as nvarchar(2))  as [y-m-d-h]
						set @hour = @hour - 1
		end	
    set @int = @int - 1
end