Skip to content
Advertisement

Use multiple IF condition to set variable

I receive parameters to stored procedure:

Then depending of this variables I do an IF condition to set other variables like:

Is that the best way to do this? or can I do better?

Advertisement

Answer

You can do the logic all inside one statement:

User contributions licensed under: CC BY-SA
1 People found this is helpful
Advertisement