Skip to content
Advertisement

Better way to write a multiple case statement SQL

I have this query bellow. And I’m trying to find a better way to write this query that has a statement. I don’t want to store each case value in a temp table, but maybe in an array.. Any input?

Advertisement

Answer

Does IN satisfy what you want to do?

It certainly shortens the code.

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