>If there is a way for you to easily test this approach, I would try it. Set based updates can be vastly quicker.
It can but this is highly risky. Replacing a few fields in a table is something. But, replacing 240 fields is another, especially on 4 million records where this is the most important table of the product.