What method are you using to update the rows (in your original solution)? Is this a Data Warehouse? What is the size of the table?