[步骤]
declare @p3 dbo.Tb_StringIdsinsert into @p3 values(0)exec sp_executesql N'SELECT oi.CustomerID, oi.WareHouseID, ol.SKU, Sum(ol.ProductNum + ol.ProductNumUpdate - ol.LockNum) UnLockProductNum,oi.IsStockOrder FROM RB_OrderInfo oi WITH(NOLOCK) INNER LOOP JOIN RB_OrderList ol WITH(NOLOCK) ON oi.CustomerID = ol.CustomerID AND oi.OrderCode = ol.OrderCode JOIN RB_WareHouse wh WITH(NOLOCK) ON oi.CustomerID = wh.CustomerID AND oi.WareHouseID = wh.ID INNER LOOP JOIN RB_OrderSource os WITH(NOLOCK) ON oi.CustomerID = os.CustomerID AND oi.OrderSourceID = os.ID LEFT JOIN @Tb_OrderCodes t ON t.Id=oi.OrderCode WHERE oi.CustomerID IN ( 1 ) 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 oi.WareHouseID > 0 AND wh.WareHouseType = 1 AND OS.OrderSourceType <> 20 AND ISNULL(t.Id,'''')='''' GROUP BY oi.CustomerID, oi.WareHouseID, ol.SKU,oi.IsStockOrder ',N'@Tb_OrderCodes [Tb_StringIds] READONLY,@OrderStatus varchar(5)',@Tb_OrderCodes=@p3,@OrderStatus='1,6,0'
[结果]
[期望]
过滤掉 无效请求 ，并且把 oi.CustomerID IN ( 1 ) 改成 oi.CustomerID =1
