AI时代，找源码已成为过去式，纪念我过去的十年0(回)
75天前
还有人吗2(回)
93天前会python真的可以为所欲为0(回)
573天前
这里还有人吗2(回)
758天前这里还有人吗0(回)
758天前
每天面对着电脑屏幕，敲打键盘。我所面对的并不只是代码，而是一种生活方式。0(回)
983天前USE AdventureWorks2012; |
GO |
CREATE TABLE Production.UpdatedInventory |
(ProductID INT NOT NULL, LocationID int, NewQty int, PreviousQty int, |
CONSTRAINT PK_Inventory PRIMARY KEY CLUSTERED (ProductID, LocationID)); |
GO |
INSERT INTO Production.UpdatedInventory |
SELECT ProductID, LocationID, NewQty, PreviousQty |
FROM |
( MERGE Production.ProductInventory AS pi |
USING (SELECT ProductID, SUM(OrderQty) |
FROM Sales.SalesOrderDetail AS sod |
JOIN Sales.SalesOrderHeader AS soh |
ON sod.SalesOrderID = soh.SalesOrderID |
AND soh.OrderDate BETWEEN '20030701' AND '20030731' |
GROUP BY ProductID) AS src (ProductID, OrderQty) |
ON pi.ProductID = src.ProductID |
WHEN MATCHED AND pi.Quantity - src.OrderQty >= 0 |
THEN UPDATE SET pi.Quantity = pi.Quantity - src.OrderQty |
WHEN MATCHED AND pi.Quantity - src.OrderQty <= 0 |
THEN DELETE |
OUTPUT $action, Inserted.ProductID, Inserted.LocationID, Inserted.Quantity AS NewQty, Deleted.Quantity AS PreviousQty) |
AS Changes (Action, ProductID, LocationID, NewQty, PreviousQty) WHERE Action = 'UPDATE'; |
GO |
by: 发表于：2017-09-22 09:43:06 顶(0) | 踩(0) 回复
？？
回复评论