[步骤]

(@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，建议整改