• code snippets
  • all code snippets/
  • popular code snippets/
  • your code snippets
• extras
• blog
• about snipplr

• Big /
• Small

Posted By

RealRover on 08/07/10

Tagged

case when THEN

Versions (?)

08/07/10 06:34am

Who likes this?

1 person have marked this snippet as a favorite

Tyster

 / Published in: SQL

 

CASE 
      WHEN @RoleTypeId = 0 THEN @RoleTypeName
      WHEN @RoleTypeId = 1 THEN 'Public Anonymous User'
      WHEN @RoleTypeId = 2 THEN 'System Administrator'
 END

Report this snippet   Tweet