arithmetic overflow error

#1

Hello,

I have a column of datatype int which has about 100000 rows and i am trying
to sum up the column and i am
getting the arithmetic overflow errror

This is the sql

Declare @tot bigint
Select @tot = sum(column1) from tab1
Select @tot

#2

Hi,

TRY CAST(AS BIGINT)

Quote:

Select @tot = sum(column1) from tab1
Select @tot = sum(CAST(column1 AS BIGINT)) from tab1

-------
SHINICHI YONEDA MXL04371 (AT) nifty (DOT) ne.jp
Microsoft Most Valuable Professional
MVP for SQL Server 2002-2003

"SCSQL" <chalasani (AT) mcleodusa (DOT) net> wrote

Quote:

Hello,

I have a column of datatype int which has about 100000 rows and i am
trying
to sum up the column and i am
getting the arithmetic overflow errror

This is the sql

Declare @tot bigint
Select @tot = sum(column1) from tab1
Select @tot

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

arithmetic overflow error

microsoft.public.sqlserver.server microsoft.public.sqlserver.server

arithmetic overflow error - 10-17-2003 , 04:50 PM

Re: arithmetic overflow error - 10-17-2003 , 05:05 PM