I am migrating data from one table to a new table. The old table uses FLOAT, and in the new table I am using DECIMAL as the field attribute.

I am using the following statement which worked fine:
CAST(OLD\_COLUMN\_NAME as DECIMAL(9,2) AS 'NEW\_COLUMN\_NAME'

that works like a charm until I hit the bump in the road. The old data is defined as float,null, the new field is defined as decimal(5,5). I understand that decimal(5,5) will requires all data behind the decimal for 5 positions. Just wondering if they is any way to handle this problem of moving data from a float data field to a decimal data field. 

The input data from the old field is varied and looks like this: 5, 0.5, 0.5, 0.75, 2, and so forth.

The error I am receiving is:

> 
> Msg 8115, Level 16, State 6, Line 8 Arithmetic overflow error converting float to data type numeric.The statement has been terminated.
> 
> 
> 

The code is against a SQL SERVER 2005 database using SQL SERVER 2008. Not sure this matters, but thought I would include this information.

Could someone shed some light on how to address this data conversion issue? Thank you!