Case statement in sql

• fmalola

  SSC Enthusiast

  Points: 120

  More actions

  March 19, 2008 at 4:02 am

  #183514

  Hi,

  I have been trying to find a way to use a case statement in sql e.g

  switch(ApprovalID)

  {

  case 1:

  break;

  }

  Is there a way that I can do something similar in sql?

• Jeff Moden

  SSC Guru

  Points: 1004565

  More actions

  March 19, 2008 at 6:15 am

  #791395

  Yes... lookup CASE, BREAK, and RETURN in Books Online (comes free with SQL Server)

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  

• Jeff Moden

  SSC Guru

  Points: 1004565

  More actions

  March 19, 2008 at 6:16 am

  #791397

  Jeff Moden (3/19/2008)

  ---

  Yes... lookup CASE, BREAK, and RETURN in Books Online (comes free with SQL Server)

  On second thought... it looks more like you're trying to do control of flow... lookup IF, and RETURN in Books Online.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)