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 aset @sql = @sql + ' from tb group by name'exec(@sql)  这个Sql 语句 哪里错了  ，找了半天也没找出来，求大神 帮下忙  

Answer 1

from (select distinct Subject from tb) as a

这个你怎么在单引号外？