Sorry Lynn

You pointed me in the right direction. If I change the data type back to decimal and make it 10,2 it works.

I wasn't aware the scale was actual...

Ok this works but is odd

If I change the Pkg_Per to a float data type it works. Although It gives me back way to many decimal places even if I...

All three fields are Decimal

I did and get this error

Server: Msg 8115, Level 16, State 8, Line 1

Arithmetic overflow error converting numeric to data type numeric.

The statement has been terminated.

******************

UPDATE Met_PkgMetrics

SET Pkg_Per = cast(Installed_Clients...