The column is a decimal(5,2) -- it is actually the target column.. it updates to its own value if the case statement is not capturing a change for that scenario.

I will try a select into..

thank you both for responding.