5 Comments

1. sema says:

   August 16, 2011 at 11:51 am

   is there any limitation of the number of case statements that we can use in one select statement.
   thanks…

   Reply to this comment
   • Derek Dieter says:

     August 16, 2011 at 11:52 am

     Hi Sema, no there is not.

     Good luck,
     Derek

     Reply to this comment
2. Jasvinder says:

   January 14, 2011 at 4:17 am

   Name =
   Case @searchString
   when ‘ ‘ then Not SurvUserHier.EmpId
   When ‘eq’ then SurvUserHier.EmpId
   end)

   I want to use NOT in the then, but its giving error any suggestions

   Reply to this comment
   • Derek Dieter says:

     August 16, 2011 at 11:54 am

     Hi Jasvinder,

     In that case (hehe).. you need to break the case statement out.

     Name =
     Case when @searchString = ‘eq’ THEN SurvUserHier.EmpId END

     You don’t need an ELSE.

     Reply to this comment
3. Hans Fransson says:

   November 8, 2010 at 2:30 pm

   Hi!
   I wonder if you can help me with a convert problem in a case expression?
   The result would be like..
   name, customer
   Anna, 5
   Hans, 10
   Curt, No customer
   I must make an convert in the case, and here is my code…
   WHEN COUNT( k.customer) = 0 THEN ‘No customer’
   ELSE COUNT(CONVERT(char(20),CONVERT(int, k.customer)))
   What is wrong!
   Please help!
   Hans Fransson // Sweden

   Reply to this comment