When I try to get the sum of a column from a table I get the error Arithmetic overflow error converting expression to data type int because the resulting number is to big for an INT. So I tried to CAST to a BIGINT using the following
SELECT CAST(SUM(columnname) AS BIGINT) FROM tablename
This gives me the same error. Any ideas what i'm doing wrong?