sql ´æ´¢¹ý³ÌÎÊÌâ

SQL code:
declare @t varchar(5000)
set @t=''
select @t=@t+',[È¡Ïû·ÖÎö-'+quXiaoFenXi+']=sum(case when [quXiaoFenXi]='+quotename([quXiaoFenXi],'''')+' then shangPinZongShu else 0 end)'
from tb_gyyDingDan where zhuangtai =0 group by quXiaoFenXi
print(@t)

declare @s varchar(8000)
set @s=''
set @s='select LEFT(xiadanshijian,10) as ÈÕÆÚ,sum(shangPinZongShu) as ¶©µ¥ÉÌÆ·×ÜÊý,sum(shangPinZongJinE) as ¶©µ¥ÉÌÆ·×ܽð¶î ,
[È¡ÏûÊýÁ¿]=sum(case when [zhuangTai]=0 then [shangPinZongShu] else 0 end),
[È¡Ïû½ð¶î]=sum(case when [zhuangTai]=0 then [shangPinZongJinE] else 0 end),
[ÏúÊÛÊýÁ¿]=sum(case when [zhuangTai] in (11,13,14) then [shangPinZongShu] else 0 end),
[ÏúÊÛ½ð¶î]=sum(case when [zhuangTai] in (11,13,14) then [shangPinZongJinE] else 0 end)'+@t+'from dbo.tb_gyyDingDan
where zhuangtai in (0,11,13,14) and (xiadanshijian >=''2009-08-01 00:00:00'' and xiadanshijian<=''2009-08-31 23:59:59'')
group by LEFT(xiadanshijian,10)
union all
select ''ºÏ¼Æ'',sum(shangPinZongJinE),sum(shangPinZongShu),
[È¡ÏûÊýÁ¿]=sum(case when [zhuangTai]=0 then [shangPinZongShu] else 0 end),
[È¡Ïû½ð¶î]=sum(case when [zhuangTai]=0 then [shangPinZongJinE] else 0 end),
[ÏúÊÛÊýÁ¿]=sum(case when [zhuangTai] in (11,13,14) then [shangPinZongShu] else 0 end),
[ÏúÊÛ½ð¶î]=sum(case when [zhuangTai] in (11,13,14) then [shangPinZongJinE] else 0 end)'+@t+' fr