you are crossing the boundaries of money datatype choose
an alternative datatype to store value of 999999999999999
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.
-----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
But what is puzzling me is that I am getting this error
one database but not on another (with the exact same
structure and datatype (money) fo rthe BxferAmount
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?