Today I was trying to join two table each having approximately 1 million records in one of my SQL Server 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.
The work around which did the trick for me is, instead of "Count" I changed it as "Count_big".
The work around which did the trick for me is, instead of "Count" I changed it as "Count_big".
