Formula parsing

• Felipe Maurer

  SSC Enthusiast

  Points: 132

  More actions

  July 11, 2006 at 2:49 pm

  #118778

  Hi I'm looking for an efficient way to substitute parameter values into a varchar containing a formula. For example:

  @formula = '@price * @vat'

  @price=10

  @vat=0.1

  I need a way to go from that formula to '10 * 0.1' so that I can evaluate it using exec('select '+@formula)

  Any ideas?

• Aaron Ingold

  SSCrazy Eights

  Points: 9070

  More actions

  July 11, 2006 at 2:51 pm

  #648586

  Why use EXEC()?

  DECLARE @price DECIMAL

  , @vat DECIMAL

  , @total DECIMAL

  SET @vat = 0.1

  SET @price = 10

  SET @formula = @vat * @price

• Felipe Maurer

  SSC Enthusiast

  Points: 132

  More actions

  July 11, 2006 at 3:02 pm

  #648591

  Because the formula will be passed as a parameter, since it will be stored in a field in a table and different formulas will be applied to different situations.

• Sergiy

  SSC Guru

  Points: 110208

  More actions

  July 11, 2006 at 3:32 pm

  #648597

  Check out sp_executesql in BOL.

  _____________
  Code for TallyGenerator

• Felipe Maurer

  SSC Enthusiast

  Points: 132

  More actions

  July 11, 2006 at 3:43 pm

  #648598

  Thx