Re: Arithmetic overflow...

#1

you are crossing the boundaries of money datatype choose
an alternative datatype to store value of 999999999999999
probably bigint/decimal.

From BOL

Monetary data values from -2^63 (-
922,337,203,685,477.5808) through 2^63 - 1
(+922,337,203,685,477.5807), with accuracy to a ten-
thousandth of a monetary unit.

Look for the topic "Data Types" in Books Online.

-Vishal

Quote:

-----Original Message-----
Hello and thanks for your help in advance. My issue is
that when I run this query:

SELECT * FROM MtBookXfers
WHERE ((BXferEnterDateTime >= '07/31/2003 00:00:00')
AND (BXferEnterDateTime < '08/01/2003 00:00:00'))
AND ((BXferAmount >= 999999999999999))

I am getting this error:

Server: Msg 8115, Level 16, State 4, Line 1
Arithmetic overflow error converting numeric to data
type
money.

But what is puzzling me is that I am getting this error
on
one database but not on another (with the exact same
structure and datatype (money) fo rthe BxferAmount
field)
I am not getting a error...just 0 rows returned. Both of
the DB's reside on the same server(SQL 2000) as well.

Could someone please advise?
Thanks,
Sam
.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Arithmetic overflow...

microsoft.public.sqlserver.mseq microsoft.public.sqlserver.mseq

Re: Arithmetic overflow... - 07-31-2003 , 10:04 PM