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.
| Author |
Topic |
|
arandall
Starting Member
2 Posts |
 Posted - 2009-07-09 : 16:05:58
|
I'm getting the following error at times.
"arithmetic overflow error converting expression to data type float"
Now the SQL Statement I am running is:-
SELECT @x = Cos(@lat1) * Cos(@lat2) * Cos(@long1 - @long2) + Sin(@lat1) * Sin(@lat2)
The data is:-
SELECT @x = Cos(0.585524802788309) * Cos(0.587051965883804) * Cos(1.47653458455319 - 1.47164242665985) + Sin(0.585524802788309) * Sin(0.587051965883804)
I will work every time I run it manually in SQL. The proc that is running is part of another proc, and we run it 50 or so times in a few seconds. It will randomly fail one or two times for the 50 of so sets of data put in. I don't think its the data or even the proc, so my guess is something in the setup of SQL somewhere that is choking when it hits some kind of data limit.
I know I am grasping at straws, but any ideas? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-07-09 : 16:21:15
|
The error message also prints the line producing the error.
Does the above code correspond to the error line?
N 56°04'39.26"
E 12°55'05.63" |
 |
|
|
arandall
Starting Member
2 Posts |
Posted - 2009-07-09 : 16:28:53
|
| Yes it does, and it returns a NULL. But I run 50 data sets at a time, and its random on what one it fails on, and also the same data set a second time will fail with a different set of data, hence it cannot be data. |
|
|
|
|
|
|
Quirky Overflow Error - Stumped