Re: trig errors
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Wed, 30 Jan 2008 22:48:22 +0000 (UTC)
Daft Pict (brianjmclean@xxxxxxxxx) writes:
Greetings,
I am getting a data conversion error I cannot explain!
This statement
UPDATE dbImageList
set cx = COS(RADIANS(CRVAL2))*COS(RADIANS(CRVAL1)),
cy = COS(RADIANS(CRVAL2))SIN(RADIANS(CRVAL1)),
cz = SIN(RADIANS(CRVAL2))
results in this error message
Msg 8115, Level 16, State 2, Line 1
Arithmetic overflow error converting expression to data type float.
The statement has been terminated.
However, all fields crval1,crval2,cx,cy,cz are datatype float in the
table.
Any suggestions on how to perform this computation?
I would certainly help if you could post a script that demonstrates
the problem. That is, the script would include the CREATE TABLE statement
for the table, and INSERT statements for data that causes this problem.
Else we are left a bit in the dark.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- References:
- trig errors
- From: Daft Pict
- trig errors
- Prev by Date: Re: Create Table with Variable included in Table Name
- Next by Date: Join 4 tables - can it be done?
- Previous by thread: trig errors
- Next by thread: Re: trig errors
- Index(es):
Relevant Pages
|
