David-
try redeclaring your INTEGER columns as BIGINT instead of INTEGER http://dev.mysql.com/doc/mysql/en/Numeric_types.html
HTH,
Martin Gainty
From: "David Mohorn" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: T-SQL SUM() Overflow?
Date: Mon, 16 Aug 2004 11:37:12 -0500
MIME-Version: 1.0
Received: from lists.mysql.com ([213.136.52.31]) by mc1-f9.hotmail.com with Microsoft SMTPSVC(5.0.2195.6824); Mon, 16 Aug 2004 09:39:52 -0700
Received: (qmail 9896 invoked by uid 109); 16 Aug 2004 16:37:22 -0000
Received: (qmail 9877 invoked from network); 16 Aug 2004 16:37:22 -0000
Received: neutral (lists.mysql.com: local policy)
X-Message-Info: 6sSXyD95QpX8hhZnhYoqefW/otoY+LQE
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
List-ID: <mysql.mysql.com>
Precedence: bulk
List-Help: <mailto:[EMAIL PROTECTED]>
List-Unsubscribe: <mailto:[EMAIL PROTECTED]>
List-Post: <mailto:[EMAIL PROTECTED]>
List-Archive: http://lists.mysql.com/mysql/171030
Delivered-To: mailing list [EMAIL PROTECTED]
Message-ID: <[EMAIL PROTECTED]>
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook, Build 10.0.2627
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
In-Reply-To: <[EMAIL PROTECTED]>
X-Virus-Checked: Checked
Return-Path: [EMAIL PROTECTED]
X-OriginalArrivalTime: 16 Aug 2004 16:39:52.0808 (UTC) FILETIME=[A7A10680:01C483AF]
Hello, I'm trying to run a T-SQL query that will SUM a column of type INT. I'm, however, receiving the following error:
"Arithmetic overflow error converting expression to data type int."
The four rows that its trying to sum have values of 3098082, 2488114, 316804, and 10657.
What do I do?
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
_________________________________________________________________
Don’t just search. Find. Check out the new MSN Search! http://search.msn.click-url.com/go/onm00200636ave/direct/01/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
