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?
--
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