Turning off Arithmetic Overflow error converting float to data type numeric.

Arithmetic overflow error converting float to data type numeric.The statement has been terminated.

Use following statement in your stored proc

 

SET ANSI_WARNINGS OFF
SET ARITHABORT OFF