[步骤]

SELECT WareHouseID,Number,SKU,OrderSourceSKU,AssociatedBallanceNumber 
                                FROM RB_Inventory_InOutBallance WITH(nolock)                                   
                                WHERE CAST(AssociatedBallanceNumber AS VARCHAR(100)) IN ('11150529','11150530','11150531','11150546','11165393','11165400','11165402','11165407','11165409','11165411','11165416','11165418','11165425','11165398','11165412','11165413','11150547','11150548','11150549','11150563','11150564','11150565','11150566','11294078','11294080','11294085','11294087','11300938','11300942','11300943','11300944','11300945','11150579','11150580','11150581','11300922','11300924','11150592','11150594','11150601','11150582','11150596','11150597','11150598','11150599','11150613','11150614','11150615','11150616','11150629') and CustomerID=1 and OperateType = 47

[结果]

[期望]

去掉类型转换 CAST(AssociatedBallanceNumber AS VARCHAR(100))