What I’m trying to do is use more than one CASE WHEN condition for the same column.

Here is my code for the query:

   SELECT   Url="",
            p.ArtNo,
            p.[Description],
            p.Specification,
            CASE 
            WHEN 1 = 1 or 1 = 1 
               THEN 1 
               ELSE 0 
            END as Qty,
            p.NetPrice,
            [Status] = 0
      FROM  Product p (NOLOCK)

However, what I want to do is use more then one WHEN for the same column “qty”.

As in the following code:

IF
// CODE
ELSE IF
// CODE
ELSE IF
// CODE
ELSE
// CODE

11 Answers
11

Leave a Reply

Your email address will not be published. Required fields are marked *