[步骤]
GetSingle:SELECT Count(1) AS OrderStatusCount FROM RB_Procurement_Order_Package (nolock)p WHERE p.CustomerID = @CustomerID AND p.PackageState = @PackageState AND p.MergerPackageNo IN (SELECT d.MergerPackageNo FROM RB_Procurement_Order_Package_OrderDetail d WITH(nolock) LEFT JOIN RB_OrderInfo o WITH(nolock) ON d.OrderCode = o.OrderCode AND d.CustomerID = o.CustomerID WHERE d.CustomerID = @CustomerID AND o.OrderStatus = @OrderStatus AND o.AddTime >= @OrderStartTime) AND p.AddTime >= @StartTime AND p.IsStockOrderWithPackage = 0 AND p.WareHouseID IN (333,18061) Param:@CustomerID = 1 ,@PackageState = 1 ,@OrderStartTime = 2024/4/22 0:00:00 ,@StartTime = 2024/6/22 0:00:00 ,@OrderStatus = 3 ,
[结果]
[期望]
把IN 的数据太多 建议改成关联
该SQL查询的是4月份的历史包裹数据，所以现在执行SQL查询到的数据是一样的。
而且查询页面，不是自动服务，不会大量操作
只需要2秒就能查询出来，是不是其他地方影响到了