A Summarization Problem

Mar 3, 2006

altimebest1 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."

View 1 Replies


ADVERTISEMENT

Date Formating For Summarization

Oct 1, 2003

How do I format a date field to monthly and/or yearly only in order to summarize totals in another field.

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved