您可以使用另一种方法：
SELECt * FROM dbo.tblOrders oWHERe o.OrderId IN (SELECt [Value] FROM [dbo].[udf_GenerateVarcharTableFromStringList](@OrderId, ','))AND ((@ActiveInactive = 'Active' AND o.[orderactivedate] > o.[orderinactivedate])OR (@ActiveInactive = 'Inactive' AND o.[orderactivedate] < o.[orderinactivedate]))
