Tuesday, February 9, 2010

Arithmetic overflow error converting expression to data type int

The "Arithmetic overflow error converting expression to data type int." error occurs when the computing field's result is bigger than the size of the data type defined.

The error can also occur using COUNT(*). Try using the COUNT_BIG(*)

No comments: