Mathematical Functions in SQL

• sanjsharma

  Grasshopper

  Points: 14

  More actions

  February 18, 2010 at 4:18 am

  #98991

  Im am trying to rewrite a vba Function into T-SQL

  I have a math calculation in vba which correctly calculates

  (1 - 1.5 * (0.11852 - 0.05478 * Log((3.00/ 10000))) ^ 2)

  to 0.524748374189154

  I cant get it to work in sql, Ive currently at

  power(1 - 1.5 * (0.11852 - 0.05478 * Log((3.00/ 10000))) ,2)

  which gives a different answer.

  Am I doing something wrong?

• Henrico Bekker

  One Orange Chip

  Points: 27652

  More actions

  February 18, 2010 at 4:31 am

  #1120790

  sanjsharma (2/18/2010)

  ---

  Im am trying to rewrite a vba Function into T-SQL

  I have a math calculation in vba which correctly calculates

  (1 - 1.5 * (0.11852 - 0.05478 * Log((3.00/ 10000))) ^ 2)

  to 0.524748374189154

  I cant get it to work in sql, Ive currently at

  power(1 - 1.5 * (0.11852 - 0.05478 * Log((3.00/ 10000))) ,2)

  which gives a different answer.

  Am I doing something wrong?

  select power(1 - (1.5 * ((0.11852 - 0.05478) * Log((3.00/ 10000)))) ,2)

  returns

  3.15262155946613

  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

• sanjsharma

  Grasshopper

  Points: 14

  More actions

  February 18, 2010 at 4:38 am

  #1120797

  Thanks for your reponse.

  Ive worked it out now, I had the power in the wrong place

  it shouls have been

  select (1 - 1.5 * power((0.11852 - 0.05478 * Log((3.00 / 10000))) ,2))

  Thanks