复制SELECT P.ProductID ,商业CONVERT(INT,CONVERT( CHAR(4), YEAR(H.OrderDate) ) + RIGHT(0+ CONVERT(VARCHAR(3), MONTH(H.OrderDate) ),2) + RIGHT(0+ CONVERT( VARCHAR(3), DAY(H.OrderDate) ),2)) AS OrderDateKey ,C.AccountNumber ,SUM(D.OrderQty) AS OrderQuantity ,SUM(D.LineTotal) AS SalesAmount FROM [Sales].[SalesOrderDetail] D INNERJOIN [Sales].[SalesOrderHeader] H ON (D.SalesOrderID = H.SalesOrderID) INNERJOIN [Production].[Product] P ON (D.ProductID = P.ProductID) INNERJOIN [Sales].[Customer] C ON (H.CustomerID = C.CustomerID) WHERE H.OnlineOrderFlag = 1 GROUPBY P.ProductID ,H.OrderDate ,C.AccountNumber 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.