Arithmetic overflow error when summing an INT, how do I cast it as a BIGINT?

Try converting it before summing. eg.

SELECT SUM(CONVERT(bigint, columnname)) FROM tablename

SELECT SUM(CAST(columnname AS BIGINT)) FROM tablename

CodeHunter