There are three formats of case expression. You can do CASE with many WHEN as;
CASE WHEN Col1 = 1 OR Col3 = 1 THEN 1
WHEN Col1 = 2 THEN 2
...
ELSE 0 END as Qty
Or a Simple CASE expression
CASE Col1 WHEN 1 THEN 11
Max Angelo Dapitilla Perin
Posted on
Answer: How do I do multiple CASE WHEN conditions using SQL Server 2008?
For further actions, you may consider blocking this person and/or reporting abuse
Top comments (0)