SQL 动态列转行

Question

declare @sql varchar(8000)
set @sql ='select Name as 姓名'
select @sql = @sql+' , max(case Subject when ''' + Subject + ''' then Result else 0 end) Subject'
from (select distinct Subject from tb) as a
set @sql = @sql + ' from tb group by name'
exec(@sql)

  这个Sql 语句 哪里错了  ，找了半天也没找出来，求大神 帮下忙  

Answer 1

from (select distinct Subject from tb) as a这个你怎么在单引号外？