[步骤]
(@CustomerID int,@OrderSourceType int,@SKU nvarchar(50),@WareHouseType int,@Country nvarchar(50),@ShipTime datetime)SELECT TOP 1 ShipFee+BaseShipFee FROM RB_WareHouse_Inventory_Transfer_Log sl(NOLOCK) INNER JOIN RB_OrderInfo oi(NOLOCK) ON sl.CustomerID=oi.CustomerID AND sl.OrderCode=oi.OrderCode INNER JOIN RB_WareHouse wh(NOLOCK) ON wh.CustomerID=oi.CustomerID AND wh.ID=oi.ToWareHouseID INNER JOIN RB_OrderSource os(NOLOCK) ON os.CustomerID=oi.CustomerID AND os.ID=oi.OrderSourceID WHERE sl.CustomerID=@CustomerID AND sl.SKU=@SKU AND os.OrderSourceType=@OrderSourceType AND sl.ShipTime<@ShipTime AND wh.WareHouseType=@WareHouseType AND os.OrderSourceCountry=@Country AND sl.OrderCode NOT LIKE 'P%' AND sl.OrderCode NOT LIKE 'XN%' ORDER BY sl.ShipTime DESC;
[结果]
[期望]
系统 SKU 为 varchar ，传入 nvarchar，建议整改
