[Quote=引用 10 楼 orange1983 的回复:]
我的代码如下
以前是的动态sql是
declare @sql1 varchar(4000)
set @sql1='select 0'
select @sql1=@sql1+',['+sDeptName+']=sum(case sDeptName when '''+sDeptName+''' then MoneyAll else '' '' end)' from (select sDeptName from HrmDept where sDeptId <='04')a
set @sql1='select dDate,'+substring(@sql1,10,len(@sql1))+' from ViewMoneyBackDay group by dDate'
exec(@sql1)
改完后是
declare @sql1 v…
[/Quote]