List:General Discussion« Previous MessageNext Message »
From:Martin Gainty Date:August 16 2004 5:09pm
Subject:RE: T-SQL SUM() Overflow?
View as plain text  
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" <dm4714@stripped>
>To: <mysql@stripped>
>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 mysql-help@stripped; run by ezmlm
>List-ID: <mysql.mysql.com>
>Precedence: bulk
>List-Help: <mailto:mysql-help@stripped>
>List-Unsubscribe: 
><mailto:mysql-unsubscribe-mgainty=hotmail.com@stripped>
>List-Post: <mailto:mysql@stripped>
>List-Archive: http://lists.mysql.com/mysql/171030
>Delivered-To: mailing list mysql@stripped
>Message-ID: <00c001c483af$48b7ff70$6901a8c0@gateway1>
>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: <1092672786.28395.202426224@stripped>
>X-Virus-Checked: Checked
>Return-Path: mysql-return-171030-mgainty=hotmail.com@stripped
>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/mysql?unsub=1
>

_________________________________________________________________
http://search.msn.click-url.com/go/onm00200636ave/direct/01/

Thread
Can connect with PHP to MYSQLleegold13 Aug
  • Re: Can connect with PHP to MYSQLsuomi13 Aug
  • Re: Can connect with PHP to MYSQLWesley Furgiuele13 Aug
    • Re: Can connect with PHP to MYSQLleegold13 Aug
      • Re: Can connect with PHP to MYSQLAndreas Ahlenstorf13 Aug
        • SQL question, SELECT DISTINCTleegold16 Aug
          • Re: SQL question, SELECT DISTINCTSGreen16 Aug
            • Re: SQL question, SELECT DISTINCTleegold16 Aug
              • T-SQL SUM() Overflow?David Mohorn16 Aug
              • Re: SQL question, SELECT DISTINCTSGreen16 Aug
                • Re: SQL question, SELECT DISTINCTleegold16 Aug
                  • Re: SQL question, SELECT DISTINCTMichael Stassen16 Aug
RE: T-SQL SUM() Overflow?Martin Gainty16 Aug
Re: SQL question, SELECT DISTINCTleegold16 Aug
  • Re: SQL question, SELECT DISTINCTMichael Stassen16 Aug
    • Re: SQL question, SELECT DISTINCTleegold16 Aug
Re: SQL question, SELECT DISTINCTleegold16 Aug
Re: SQL question, SELECT DISTINCTStephen E. Bacher17 Aug
  • Re: SQL question, SELECT DISTINCTMichael Stassen17 Aug