Arithmetic overflow error while executing T-SQL Query

Question

select COUNT(*)  from T1,T2

In the above query I just try to get the number of possible permutation combination can be made. Both are very huge table which have 27182708 rows.

When I try to execute above query it throws Arithmetic overflow error.

I have tried bigint conversion also but same response.

Any suggestions ?

Abe Miessler · Accepted Answer · 2014-04-29 17:18:52Z

4

Try using COUNT_BIG instead. This will return a bigint instead of an int, which may solve your problem.

Also, while it probably doesn't make a huge difference here, using ANSI Joins is a bad habit to get into.

answered Apr 29, 2014 at 16:43

Abe Miessler

85.6k104 gold badges323 silver badges496 bronze badges

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

1 Comment

You will need to cast those numbers as bigint before you multiply them.