您可以尝试这样： -

You can try like this:-

declare @columns varchar(max)
declare @convert varchar(max)
select @columns =stuff((select '],[' + particular from tblName order by '],['
                                   + convert(varchar(max),points) desc
                                     for xml path('')),1,2,'') + ']'

--Select @columns column

 set @convert= 'select * from (select * from tblName) contributors
                            pivot (sum(points) for particulars in (' +@Columns + ')) as                               pivottbl'


--select @convert
execute (@convert)

PIVOT可能有助于解决您的问题。请试试。

PIVOT may help for your problem. Please try it.