sql server行转列

SELECT PrecinctID,MAX(company) as company,MAX(voucher_type) as voucher_type,MAX(voucher_making_system) as voucher_making_system,
MAX(receiver) as receiver,MAX(sender) AS sender,MAX(xmzhda_receiver) AS xmzhda_receiver,MAX(xmzhda_sender) AS xmzhda_sender,
MAX(URL) AS URL,MAX(xmzhda_url) AS xmzhda_url,MAX(mph_itemtype) AS mph_itemtype,MAX(gfkh_itemtype) AS gfkh_itemtype
FROM Wygl_Charge_UfinterfaceForPrecinct ufp WITH(nolock)
PIVOT(MAX(AttributeValue) FOR AttributeKey IN (company,voucher_type,voucher_making_system,receiver,sender,xmzhda_receiver,xmzhda_sender,URL,xmzhda_url,mph_itemtype,gfkh_itemtype))
AS pvt WHERE PrecinctID!=0 GROUP BY PrecinctID