For the same column, I'm attempting to use multiple CASE WHEN conditions.
Here is my code for the query:
WHEN 1 = 1 or 1 = 1
END as Qty,
[Status] = 0
FROM Product p (NOLOCK)
What I want to do is use more than one WHEN for the same column "qty".
As in the following code:
Can someone please help me with this?