SELECT SUM causes error 1

[limester]

Hi There,

When trying to run a query:

select sum(col1) from table

I get the following error:

Server: Msg 8115, Level 16, State 2, Line 1
Arithmetic overflow error converting expression to data type int.

Is there anyway to avoid this to get the results I need?

Thanks!

 

[gmmastros]

col1 must not be an integer data type. You could try this...

select sum(Convert(bigint, col1)) from table

If col1 is a varchar column, this may also fail due to conversion errors.



-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[limester]

excellent! thanks gmmastros!

I knew I needed to convert the int datatype was wasn't aware bigint existed!

Cheers!

 

[JackVam]

Hi

Check

http://www.mssqlcity.com/Articles/General/choose_data_type.htm

for all sql 2000 data types


All the IT jobs in one place -

http://www.ITjobfeed.com