15-unpivot-into-temp.sql

来自「SQL Server 2005基础教程一书的源代码.」· SQL 代码 · 共 15 行

USE AdventureWorks
go
SELECT pt.Discount,ISNULL([711],0.00) As Product711,
    ISNULL([747],0.00) As Product747,ISNULL([776],0.00) As Product776
INTO #Temp1
FROM
(SELECT sod.LineTotal, sod.ProductID, sod.UnitPriceDiscount as Discount
   FROM Sales.SalesOrderDetail sod) so
PIVOT
(
SUM(so.LineTotal)
FOR so.ProductID IN ([776], [711], [747])
) AS pt
ORDER BY pt.Discount