我的桌子看起来像这样
我想把这些行旋转成桌子的头。
如果我用:
SELECT [USER],[DIVISION], [COMPANY],[RIGHTS] FROM
(SELECT [USER],[ATTRIBUTE],[VALUE],[RIGHTS] FROM [AGDA_MANUAL].[dbo].[TEST] WHERE [PROC] = 'FINANCE' ) AS T1
PIVOT (MAX([VALUE]) FOR [ATTRIBUTE] IN ([DIVISION],[COMPANY])) AS T2
这就是,,我想要的
但是,有没有