62,074
社区成员
发帖
与我相关
我的任务
分享jolinkyo进来回答
你的语句：
declare @sql varchar(4000)
set @sql = 'select Name'
select @sql = @sql + ',sum(case Subject when ' ' '+Subject+' ' ' then Result end) ['+Subject+']'
from (select distinct Subject from CJ) as a
select @sql = @sql+' from CJ group by name'
exec(@sql)
如果result字段为字符串型，要实现此功能怎么写
declare @sql varchar(4000)
set @sql = 'select Name'
select @sql = @sql + ',sum(case Subject when ' ' '+Subject+' ' ' then Result end) ['+Subject+']'
from (select distinct Subject from CJ) as a
select @sql = @sql+' from CJ group by name'
exec(@sql)
如果result字段为字符串型，要实现此功能怎么写
...全文
请发表友善的回复…
发表回复
