I am having problems using the power function in SQL 2005. The syntax I am using is FScore = Power(0.89, [OScore]). FScore doesn't compute when the score is > 45. Both FScore and OScore are set to float in the underlying table. I have tried
changing the fields to numeric, decimal, int etc but still no good.
Thanks for any help anyone can provide me with on this.
View Complete Post