摘要:
DECLARE @dt1 DATETIMESET @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 dtFROM master.dbo.spt_values AS aWHERE type='P 阅读全文