[步骤]
micro-orderstrategy-domqmessage-3-9599b7574-ck65h
(@CustomerID int,@OrderStatus varchar(max) ,@Tb_OrderCodes [Tb_StringIds] READONLY) SELECT oi.CustomerID, oi.WareHouseID, ol.SKU, SUM(ol.ProductNum + ol.ProductNumUpdate - ol.LockNum) AS UnLockProductNum, oi.IsStockOrder FROM RB_OrderInfo oi INNER JOIN RB_OrderList ol ON oi.CustomerID = ol.CustomerID AND oi.OrderCode = ol.OrderCode INNER JOIN RB_WareHouse wh ON oi.CustomerID = wh.CustomerID AND oi.WareHouseID = wh.ID INNER JOIN RB_OrderSource os ON oi.CustomerID = os.CustomerID AND oi.OrderSourceID = os.ID LEFT JOIN @Tb_OrderCodes t ON t.Id = oi.OrderCode WHERE oi.CustomerID = @CustomerID AND oi.AddTime >= DATEADD(MONTH, -2, GETDATE()) AND oi.OrderState = 0 AND oi.OrderStatus IN (SELECT CAST(item AS INT) FROM Charsplitforin(@OrderStatus, ',')) AND oi.IsPay = 1 AND ol.PurchaseType < 4 AND (ol.ProductNum + ol.ProductNumUpdate - ol.LockNum) > 0 AND ol.SKU <> '' AND ol.SKU IS NOT NULL AND oi.WareHouseID > 0 AND wh.WareHouseType = 1 AND os.OrderSourceType <> 20 AND t.Id IS NULL GROUP BY oi.CustomerID, oi.WareHouseID, ol.SKU, oi.IsStockOrder
[结果]
[期望]
把SQL 补全 nolock 防止阻塞
