Arithmetic overflow on column sum in sql server

Question

I'm trying to get a column total but when i run this query i get the following error. Any advice?

SELECT SUM(Size) as total
FROM  AllDocs
Where DirName LIKE 'sites/test/test%'


ERROR:
Msg 8115, Level 16, State 2, Line 1
Arithmetic overflow error converting expression to data type int.
Warning: Null value is eliminated by an aggregate or other SET operation.

Looks like the sum of all those sizes is bigger than MAX int.... — Mitch Wheat
– Mitch Wheat, Commented Aug 3, 2009 at 15:10

Quassnoi · Accepted Answer · 2009-08-03 15:10:05Z

58

While all your sizes can fit into INT (up to 2^31 - 1), their SUM cannot.

Cast them into BIGINT:

SELECT  SUM(CAST(Size AS BIGINT)) as total
FROM    AllDocs
WHERE   DirName LIKE 'sites/test/test%'

answered Aug 3, 2009 at 15:10

Quassnoi

427k94 gold badges628 silver badges623 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Arithmetic overflow on column sum in sql server

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related