摘要： IF OBJECT_ID('MyPvt')IS NOT NULL DROP TABLE MyPvt GOCREATE TABLE MyPvt ( ProductID INT NOT NULL, 一月 MONEY, 二月 MONEY, 三月 MONEY)INSERT INTO MyPvt SELECT ProductID,[1] AS 一月,[2] AS 二月,[3] AS 三月FROM(SELECT ProductID,MONTH(OrderDate) AS OrderMonth,SubTotal FROM Orders)AS OPIVOT( SUM(SubTotal) FOR 阅读全文

摘要： IF OBJECT_ID('Orders') IS NOT NULL DROP TABLE OrdersGOCREATE TABLE Orders( ProductID INT NOT NULL, OrderDate DATETIME NOT NULL, ShipTo CHAR(20) NOT NULL, SubTotal MONEY NOT NULL);INSERT INTO OrdersVALUES(1,CAST('20090102' AS DATETIME),'SH',100);INSERT INTO OrdersVALUES(1,CAST 阅读全文