SQL生成时间临时表

create table #TempTable
(
   [ID] [int] IDENTITY (1, 1) NOT NULL PRIMARY KEY,
   [Exp0] varchar(20)
)

declare @etKdd int,
              @etKmmStr nvarchar(13),
              @etKddStr nvarchar(13),
             @etKwwStr nvarchar(13),
             @etKqqStr nvarchar(13),
             @start_Time datetime,
            @end_Time datetime,@type_Time int

set @start_Time='2012-1-1'/*设置起始时间*/
set @end_Time='2013-1-1'/*设置终止时间*/
set @type_Time=1   /*生成类型 1为天 2为周 3为月 4为季度 5为年*/

WHILE @start_Time<@end_Time /**/
begin
set @etKdd=datepart(dd,@start_Time)
set @etKddStr=cast(@etKdd as nvarchar(13))

set @etKdd=datepart(mm,@start_Time)
set @etKmmStr=cast(@etKdd as nvarchar(13))

set @etKdd=datepart(ww,@start_Time)
set @etKwwStr=cast(@etKdd as nvarchar(13))

set @etKdd=datepart(qq,@start_Time)
set @etKqqStr=cast(@etKdd as nvarchar(13))

if @type_Time=1
Begin
INSERT INTO #TempTable (Exp0) VALUES (cast(datepart(yy,@start_Time)as nvarchar(13))+'-'+@etKmmStr+'-'+@etKddStr)
SET @start_Time=DATEADD(dd,1,@start_Time)
End
if @type_Time=2
Begin
INSERT INTO #TempTable (Exp0) VALUES (cast(datepart(yy,@start_Time)as nvarchar(13))+'-'+@etKwwStr)
SET @start_Time=DATEADD(ww,1,@start_Time)
End
if @type_Time=3
Begin
INSERT INTO #TempTable (Exp0) VALUES (cast(datepart(yy,@start_Time)as nvarchar(13))+'-'+@etKmmStr)
SET @start_Time=DATEADD(mm,1,@start_Time)
End
if @type_Time=4
Begin
INSERT INTO #TempTable (Exp0) VALUES (cast(datepart(yy,@start_Time)as nvarchar(13))+'-'+@etKqqStr)
SET @start_Time=DATEADD(qq,1,@start_Time)
End
if @type_Time=5
Begin
INSERT INTO #TempTable (Exp0) VALUES (cast(datepart(yy,@start_Time)as nvarchar(13)))
SET @start_Time=DATEADD(yy,1,@start_Time) /*循环开始时间加1 直到等于设置的终止时间*/
End

Continue
End