set nocount on declare @st datetime,@et datetime,@i int,@type int --0 全部日期,1 仅工作日,2 仅周末,3 仅星期天 declare @t table(节假日日期 datetime,节假日名称 varchar(20)) select @st='2008-01-01',@et='2009-12-31',@i=0,@type=3 while @i<= datediff(dd,@st,@et) begin if @type=0 begin insert @t select dateadd(dd,@i,@st),datename(w,dateadd(dd,@i,@st)) end else if @type=1 begin insert @t select dateadd(dd,@i,@st),datename(w,dateadd(dd,@i,@st)) where datename(w,dateadd(dd,@i,@st)) not in('星期六','星期日') end else if @type=2 begin insert @t select dateadd(dd,@i,@st),datename(w,dateadd(dd,@i,@st)) where datename(w,dateadd(dd,@i,@st)) in('星期六','星期日') end else if @type=3 begin insert @t select dateadd(dd,@i,@st),datename(w,dateadd(dd,@i,@st)) where datename(w,dateadd(dd,@i,@st)) in('星期日') end set @i=@i+1 end set nocount off select * from @t