有这样的一个表:
name object sorce
a ch 98
a en 34
a ph 34
b ch 88
b en 67
b ph 89

输出结果:
name ch en ph
a 98 34 34
b 88 67 89
写出实现的SQL语句.

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 test group by name'
exec(@sql)

你看下是这样不！

呵呵.有点看不明白,可以给一些解释吗?

select a.name,sum(a.ch) as [ch],sum(a.en) as [en],sum(a.ph) as [ph]
from(
select name,score as [ch],'' as [en],'' as [ph] from table where object='ch'
union
select name,'',score as [en],'' from table where object='en'
union
select name,'','',score as [ch] as [ph] from table where object='ph'
) a
group by a.name

select name,sum(case object when ch then isnull(score,0) else o end) as ch,sum(case object when eh then isnull(score,0) else o end) as eh,sum(case object when ph then isnull(score,0) else o end) as ph from table group by name

还是你这个简单

不过我试了,你的好象运行结果不正确哦

o改成0

呵呵,我今天写了一个报表就用到你的这个方式了,学到东西啦

呵呵,我是LouisXIV那边学的