pivot-table - PIVOT tsql 中的多列

Question

我有一张这样构造的桌子

custid|prodid|calls|orders|upsell
 34   |   2  |   4 |   2  |   1

但是我需要旋转或重建表格以反映类似的东西

custid|prodid|code   |Value
34    |   2  | call  | 4
34    |   2  | order | 2
34    |   2  | upsell| 1

标签： pivot-table

Answer 1

您可以使用联合方法：

SELECT custid, prodid, 'call' AS code, calls AS [Value] FROM yourTable UNION
SELECT custid, prodid, 'order', orders FROM yourTable UNION
SELECT custid, prodid, 'upsell', upsell FROM yourTable;