今天练习MS SQL Server逆透视的功能。
首先准备一些可以逆透视的数据:
IF OBJECT_ID('tempdb.dbo.#Part_summary') IS NOT NULL DROP TABLE #Part_summary
CREATE TABLE #Part_summary (
[Item] NVARCHAR(40),
[B]DECIMAL(18,2),
[Q]DECIMAL(18,2),
[S]DECIMAL(18,2),
[T]DECIMAL(18,2),
[U]DECIMAL(18,2)
)
INSERT INTO #Part_summary ([Item],[B],[Q],[S],[T],[U])
VALUES ('098-SSSS1-WS0098-5526',0,0,500.00,0,0),
('54F-ART43-6545NN-2514',0,0,934.39,0,0),
('872-RTDE3-Q459PW-2323',0,0,0,452.44,0),
('B78-F1H2Y-5456UD-2530',0,0,0,115.06,0),
('I32-GG443-QT0098-0001',0,0,423.65,0,0),
('I38-AA321-WS0098-0506',470.87,0,0,0,0),
('K38