涂鸦,勿揪

create table count(time smalldatetime, week int)
declare @time smalldatetime,@i int
select @time=00000101 , @i=1
while @time<=09990430
begin
insert into count(time,week) values (@time,@i)
select @time = dateadd(dd,1,@time)
select @i = @i+1
if @i = 8
select @i=1
end
select * from count where right(convert(char(8),time,112),4)='0421' and @i=2