_____________________________________________________________________________________
声明:此文摘自网络,仅供学习研究之用.                                                                                                       

declare @sql nvarchar(4000)

set @sql='Select 姓名 '

Select @sql=@sql+',sum(case when CId='+convert(varchar,CId)+ ' then 成绩 else 0 end) As '''+CName+''''

   From 课程表

Print @sql

set @sql=@sql+' From 成绩表 Group By 姓名'

--Print @sql

execute sp_executesql @sql