弄好了,没人接分,帖子不能结呀!问另外一个问题吧?拼接sql 无法使用公用表达式吗? 如下面这种情况: declare @sql varchar(8000); with t as ( select rq, pf, xm, sl from tpdata a join tqbuliangxiangmu b on a.blxm = b.id where bdid=13 ) select @sql = isnull(@sql + '],[' , '') + xm from tpdata group by xmset @sql = '[' + @sql + ']' exec ('select * from (select * from tpdata ) t pivot (sum(sl) for xm in (' + @sql + ')) b')
declare @sql varchar(8000);
with t as
(
select rq, pf, xm, sl
from tpdata a join tqbuliangxiangmu b on a.blxm = b.id
where bdid=13
)
select @sql = isnull(@sql + '],[' , '') + xm
from tpdata
group by xmset @sql = '[' + @sql + ']'
exec ('select * from (select * from tpdata ) t pivot (sum(sl) for xm in (' + @sql + ')) b')