I am trying to achive the following:
Truncate the values 1680.390000000000000000
to numeric (6,3)
All works ok until i hit a value over 1000, (as above)
The code i was using is:
cos1 = 1680.390000000000000000000
CONVERT (NUMERIC(6 , 3), ROUND(COS1, 3))
I have tried a few others, but nothing seems to work..
I get the following error. "Arithmatic Overflow"
Has anyone got any suggestions