Multiple actions in case statement possible?

• Ben-347858

  Old Hand

  Points: 391

  More actions

  January 29, 2007 at 12:33 pm

  #175707

  I'm wondering if it's possible to nest multiple actions in one case statement. I basically need to do something like:

  Select

  Case

  When LTrim(RTrim(CF_Program_Broker.STD)) = 'F' Then

  LTrim(RTrim(CF_Program_Broker.STD)),

  Cast(CF_Program_Broker.Promo_Amt as float),

  Cast(CF_Program_Broker.Invoice_Price as money),

  Cast(CF_Program_Broker.Promo_Amt as money),

  Abs(.0000),

  END

  I'm not sure if this is even possible. but I need a way to change multiple fields based on what this CF_Program_Broker.STD field has for a value.

  Thanks,

  Ben

• Prasad Bhogadi

  SSCrazy Eights

  Points: 9235

  More actions

  January 30, 2007 at 3:23 am

  #686387

  You are trying to return mutliple columns inside your CASE, it is not supported, as per your requirements it is better to use IF ELSE Blocks. You can nest multiple CASE statements but you cannot perform what you have posted.

   

  Prasad Bhogadi
  www.inforaise.com

• Jeff Moden

  SSC Guru

  Points: 1004363

  More actions

  January 30, 2007 at 9:53 pm

  #686713

  You'll need one CASE per column returned... sounds long but runs very fast.

  --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)