An overflow error indicates that the number you're trying to stuff into a column or variable is too large for the column or variable's data type. For example:

DECLARE @tiny tinyint;

SET @tiny = 999;

Running this results in an overflow error. Find the numeric data type in your table and figure out why the value you're trying to put in there is too large, and you'll solve the problem.