Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 A Domian error occurred

Author  Topic 

ams006
Yak Posting Veteran

55 Posts

Posted - 2011-08-25 : 06:44:37
Hi All,

i'm getting the following error in oneof my scripts:

Msg 3623, Level 16, State 1, Line 236
A domain error occurred.

and the line it refers to is:

set @PresentValue = (select sum(CashFlow/power(1e0+@irr,cast(date-@EndDate as float)/365e0)) from #Temp1_1 Where InvestorName = @InvestorName)


Any help would be appreciated

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-08-25 : 07:45:21
see

http://www.sql-server-performance.com/2007/domain-error-occurred/

would make more sense if you can explain what you're trying to do

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -