Friday, September 26, 2014

Is this conditional WHERE clause possible?


SELECT ...
FROM ...
WHERE
Clause 1... AND
Clause 2... AND
case when @hasActualHours = 1 and Clause 3 then 1 else 0 end = 1





Saeid Hasani [sqldevelop]


No comments:

Post a Comment