sql批量生成一年中的日期并插入

DECLARE @dt1 DATETIME
SET @dt1='2013-01-01'
insert into dd_trust_calendar(Date, SalesType)
SELECT @dt1+number,case Datepart(weekday, convert(datetime,@dt1+number)-1) when 5 then 'pk' when 6 then 'spk' else 'std' end AS dt
FROM master.dbo.spt_values AS a
WHERE type='P' AND @dt1+number<'2013-12-31'