[步骤]
(@tb_CustomerId [Tb_Ids] READONLY,@tb_OrderSourceId [Tb_Ids] READONLY,@tb_SellerOrdersId [Tb_StringIds] READONLY,@tb_OrdersSourceType [Tb_Ids] READONLY) SELECT oi.SellerOrderId, SUM(TotalPrice) TotalPrice FROM RB_OrderInfo oi INNER JOIN RB_OrderSource os ON os.CustomerID = oi.CustomerID AND os.ID = oi.OrderSourceID INNER JOIN @tb_CustomerId tci ON tci.Id = oi.CustomerID INNER JOIN @tb_OrderSourceId tsi ON tsi.Id = oi.OrderSourceID INNER JOIN @tb_OrdersSourceType tos ON tos.Id = os.OrderSourceType INNER JOIN @tb_SellerOrdersId toi ON toi.Id = oi.SellerOrderId GROUP BY oi.SellerOrderId
[结果]
[期望]
添加nolock 减少阻塞
