Mathematical Functions in SQL

Question

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?

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Henrico Bekker One Orange Chip Points: 27652 More actions · Answer 1

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 · Answer 2

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