SQL Server conditional where clause based on declared variable

Question

Is it possible to have conditional where clause, based on declared variable?

Please note: my query is much more complicated than this, I am just using this example to simplify things.

Something like:

DECLARE @ITEST INT = 1

SELECT NAME, LNAME, CADDRESS
FROM JEEVEN
WHERE
CASE WHEN @ITEST = 1 THEN
(
    (EVEN_KEY > 5 AND EVEN_KEY < 10)
)
CASE WHEN @TEST = 2 THEN
(
    (EVEN_KEY > 20 AND EVEN_KEY < 30)
)

Possible duplicate of Conditional WHERE clause in SQL Server — Tanner
– Tanner, Commented Jan 13, 2018 at 10:10
This answer applies to where clauses as well as joins. More reading is here, including performance issues. — HABO
– HABO, Commented Jan 13, 2018 at 21:11

Pரதீப் · Accepted Answer · 2018-01-13 10:04:50Z

3

You are looking for this

DECLARE @ITEST INT = 1

SELECT NAME, LNAME, CADDRESS
FROM JEEVEN
WHERE (@ITEST = 1 AND EVEN_KEY > 5 AND EVEN_KEY < 10)
   OR (@ITEST = 2 AND EVEN_KEY > 20 AND EVEN_KEY < 30)

answered Jan 13, 2018 at 10:04

Pரதீப்

94.1k21 gold badges144 silver badges179 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL Server conditional where clause based on declared variable

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related