declare @sql varchar(8000)
select @sql = isnull(@sql + '],[' , '') + course from V_StudentPerformance group by course
set @sql = '[' + @sql + ']'
exec ('select * from (select * from V_StudentPerformance) a pivot (max(performance) for course in (' + @sql + ')) b')
如果我要通过条件来查询想要的资料 要怎么写