Tuesday, April 24, 2007

Arithmetic overflow error converting expression to data type int.

Today I was trying to join two table each having approximately 5 Lakhs records in one of my SQL Server 2005 database. I was trying to find the count of some field when this arithmetic overflow error was thrown.
Arithmetic overflow error converting expression to data type int.

I understood that the calculation has exceeded the maximum INT range. For better understand on this error check out this SQL Books online article and/or this KB article.

The work around which did the trick for me is, instead of "Count" I changed it as "Count_big".

No comments: