Posted by Rajesh Setty on Wednesday, November 5, 2014
Found a new issue Arithmetic conversion error in SQL Statement. Have been fighting to find issue with Query, finally found solution for the issue. It's Aggregate function Sum. We get Integer column sum as Integer, when values go beyond 4 bite then we get this error.
Solution I found, I have used Sum(Cast(<ColumnName> as bigint)) This resolved the issue.
Tags:
arithmetic overflow error converting expression data type int
