SQL Server靜態頁面導出技術3

BORDER="BORDER" ALIGN="CENTER">

'+convert(varchar(4),@year)+
'年'+@yue+'月份

星期日星期一星期二星期三星期四星期五星期六')
else
insert into ##daylist
values('

'+
convert(varchar(4),@year)+'年'+@yue+'月份

星期日星期一星期二星期三星期四星期五星期六')
end
if @tt<>0
if @xingqi < 7
set @outchar=@outchar+''+convert(varchar(2), @ri)+''
else
set @outchar=@outchar+''+convert(varchar(2), @ri)+''
else
begin
set @tt=1
set @outchar=
case
when @xingqi=1 then ''
when @xingqi=2 then ''
when @xingqi=3 then ''
when @xingqi=4 then ''
when @xingqi=5 then ''
when @xingqi=6 then ''
when @xingqi=7 then ''
end
if @xingqi < 7
set @outchar=@outchar+''+convert(varchar(2), @ri)+''
else
set @outchar=@outchar+''+convert(varchar(2), @ri)+''
end

insert into ##daylist values(@outchar)

set @yue2=@yue
set @outchar=''

fetch point3 into
@dy,@date,@yue,@ri,@xingqi,@year
end
close point3
deallocate point3

execute sp_makewebtask
@outputfile='d:\test\daylist.htm',