A Summarization Problem
Mar 3, 2006altimebest1 writes "I have summarized my table and created a view, I hoped to query preformatted reports on it but each time I run a query say
SELECT * FROM AggregatedExports
I got the query result but I received this error:
(17458 row(s) affected)
Server: Msg 8115, Level 16, State 2, Line 1
Arithmetic overflow error converting expression to data type int.
My base table is :
comCode char 7
monthcode char 2
year char 3
countryCode char 3
quantity int
fobvalue money
insurance money
freight money
I'm new in sqlserver2000 and vbstudio.net2003 I'll deeply appreciate your assistance. Thank you."