206 May 2013 @ 02:00 PDTUDAReplyNumeric Overflow errorIf the above did not work as it did not work for me with my AVG aggregate, cast it as follows: SELECT AVG( CAST( column_name AS DECIMAL(16,0))) AS new_name 
106 May 2013 @ 01:57 PDTDatabaseReplyNumeric overflow error for AVG functionTo get rid of the error use the following format and you should no longer get an error: AVG( CAST( column_name as DECIMAL(16,0)))