SQL Case语句在where子句中指定条件? [英] SQL Case statement specifiying condition in where clause?

问题描述

我有以下查询:

    SELECT * 
FROM dbo.tblOrders o
WHERE o.OrderId IN (SELECT [Value] FROM [dbo].[udf_GenerateVarcharTableFromStringList](@OrderId, ','))
AND
@ActiveInactive =
CASE 
WHEN 'Active' THEN (o.[orderactivedate] > o.[orderinactivedate])
WHEN 'Inactive' THEN (o.[orderactivedate] < o.[orderinactivedate]) 
END

这将返回

An expression of non-boolean type specified in a context where a condition is expected, near 'THEN'.

我将如何使用它?说参数是否为有效"，然后返回具有以下条件的记录?

How would I get this to work? saying if the parameter is 'Active' then return records with the following criteria?

推荐答案

您可以使用另一种方法:

You could do it an alternate way:

SELECT * 
FROM dbo.tblOrders o
WHERE 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]))

这篇关于SQL Case语句在where子句中指定条件?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！