Sunday, 2 March 2014

How use variable in the case statement



Variable in Simple CASE expression

 

  DECLARE @TestVal int
SET @TestVal = 3
 
SELECT
        CASE @TestVal
               WHEN 1 THEN 'First'
               WHEN 2 THEN 'Second'
               WHEN 3 THEN 'Third'
               ELSE 'Other'
        END

 

Variable in search case expression

DECLARE @TestVal int
SET @TestVal = 5
 
SELECT
        CASE
                WHEN @TestVal <=3 THEN 'Top 3'
               ELSE 'Other'
        END

No comments:

Post a Comment