-- select datepart(weekday,getdate()) declare @day datetime set @day='2011-04-21'while @day<'2012-01-01' begin if datepart(weekday,@day)=1 begin print Convert(varchar(10),@day,120)+' is Sunday' end else if datepart(weekday,@day)=7 begin print Convert(varchar(10),@day,120)+' is Saturday' end
declare @day datetime
set @day='2011-04-21'while @day<'2012-01-01' begin
if datepart(weekday,@day)=1 begin
print Convert(varchar(10),@day,120)+' is Sunday'
end
else if datepart(weekday,@day)=7 begin
print Convert(varchar(10),@day,120)+' is Saturday'
end
set @day=dateadd(day,1,@day)
end