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 語句 哪里錯了  ，找了半天也沒找出來，求大神 幫下忙