[步骤]

(@CustomerID int,@WareHouseType int)  SELECT alias.[ID],alias.[CustomerID],alias.[WareHouseID],alias.[SKU],alias.[PositionID],alias.[WarningNum],alias.[GoodNum],alias.[BadNum],alias.[LockNum],alias.[AddAdminID],alias.[AddAdminName],alias.[AveragePrice],alias.[HistoryInNum],alias.[HistoryOutNum],alias.[Memo],alias.[AddTime],alias.[UpdateTime],alias.[AddCycle],alias.[HaulageTime],alias.[BuyTime],alias.[SafetyDays],alias.[AvgDailySales],alias.[OrderSourceSKU],alias.[OrderSourceID],alias.[ASIN],alias.[FNSKU],alias.[isHandUpdate],alias.[BatchNum],alias.[SynchronousGoodNum],alias.[RepairTrapTime],alias.[APIUpdateTime],alias.[FirstLegShippingType],alias.[UnitBuyShipFee],alias.[FBA_Reserved_CustomerOrders],alias.[FBA_Reserved_Transfers],alias.[FBA_Reserved_Processing],alias.[IsOneProductToMorePosition],alias.[PlatformWarningNum],alias.[IsEFN],alias.[EFNCountry],alias.[IsEFNWareHouse],alias.[ProtectNum],alias.[EstimatedSaleNum],alias.[ReceiptRecordSynTime],alias.[IsHandleEFN],alias.[EfnUpdateUser],alias.[StockType],alias.[IsNARF],alias.[NARFCountry],alias.[NARFUpdateUser],alias.[OnWayNum],alias.[IsSynSuccess],alias.[Title],alias.[CombinationsValueName],alias.[OverseaProductId],alias.[UnderWayNum],alias.[UnderWayLockNum],alias.[PrepOwnerConstraint],alias.[PrepOwnerCategory],alias.[LabelOwner],alias.[Expiration],alias.[SkuCode],alias.[isDullLabel],alias.[AdjustmentOnWayNum],alias.[StorageType],alias.[PlatformOnWayNum],alias.[Last7DaysSalesOutboundQuantity],alias.[Last14DaysSalesOutboundQuantity],alias.[Last30DaysSalesOutboundQuantity]
                        FROM dbo.RB_WareHouse_Product (NOLOCK) alias
                            LEFT JOIN dbo.RB_WareHouse (NOLOCK) b
                                ON b.CustomerID = alias.CustomerID
                                   AND alias.WareHouseID = b.ID
                        WHERE alias.CustomerID = @CustomerID
                              AND b.WareHouseType = @WareHouseType
                              AND alias.GoodNum > 0
                              AND alias.UpdateTime < DATEADD(DAY, -5, GETDATE())

[结果]

[期望]

排查为什么会返回那么多数据 ，或分页处理