SELECT in T-SQL with conditional

Question

I have a way too big query using only SELECT, and I need to filter it using conditional clause WHERE. Something like this :

if (mycondition)

    set @strwhere='conditionalexpression_1'
else

    set @strwhere='conditionalexpression_2'

.. then I want to use @strwhere in WHERE, like this :

SELECT col1, col2, col3 ............
 from tablex where @strwhere

Does any way to do it ? I have tried but... nothing works fine!

@parameters will not work like that; but are you using php or C#, you could do the substitutions there - or you have to use dynamic sql (with risks of sql injection to consider) — Paul Maxwell
– Paul Maxwell, Commented Sep 11, 2014 at 3:40
what condition will your IF have? Will it have if condition on same table tablex? — AK47
– AK47, Commented Sep 11, 2014 at 4:43

Seminda · Accepted Answer · 2014-09-11 03:52:52Z

1

Do like this, build the full query first and the execute.

SET@SQLQuery='SELECT col1, col2, col3 from tablex where '
If (mycondition)

    set @SQLQuery=@SQLQuery + 'conditionalexpression_1'
else

    set @SQLQuery=@SQLQuery + 'conditionalexpression_2'

EXECUTE(@SQLQuery)

answered Sep 11, 2014 at 3:52

Seminda

1,77312 silver badges16 bronze badges

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

Collectives™ on Stack Overflow

SELECT in T-SQL with conditional

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related