(@CustomerID int,@SKU nvarchar(8),@EndShipTime datetime)SELECT TOP 1 TaxRefundFee FROM RB_WareHouse_Inventory_Transfer_Log tl(NOLOCK) INNER JOIN RB_Warehouse wh(NOLOCK) ON tl.CustomerID=wh.CustomerID AND tl.FromWareHouseID=wh.ID WHERE tl.CustomerID=@CustomerID AND tl.ShipTime>=DATEADD(DAY,-DAY(GETDATE()),DATEADD(YEAR,-1,GETDATE())) AND tl.ShipTime<@EndShipTime AND tl.SKU=@SKU AND wh.WareHouseName LIKE '%退税%' AND OrderCode NOT LIKE 'P%' AND OrderCode NOT LIKE '%X' AND TaxRefundFee>0 AND tl.BaseID=0 ORDER BY tl.ShipTime DESC
