How do I do multiple CASE WHEN conditions using SQL Server 2008?

by

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 Comment