1、declare @sql varchar(8000)
set @sql = 'select dm'
select @sql = @sql + ',sum(case xm when '''+xm+''' then value else 0 end) as ['+xm+']'
from (select distinct xm from 表A) as a
select @sql = @sql+' from 表A group by dm'exec(@sql)
go
set @sql = 'select dm'
select @sql = @sql + ',sum(case xm when '''+xm+''' then value else 0 end) as ['+xm+']'
from (select distinct xm from 表A) as a
select @sql = @sql+' from 表A group by dm'exec(@sql)
go
在grid中你做一个复杂的 join 子查询都不允许修改,应为系统自动没有办法返回,你自己写吧!这是你的语言的事不是数据库的问题