Hard to give anything resembling specifics with not much detail. I think it would be far better if you can get rid of the looping and just do an update. If you can post some ddl and sample data along with the logic of what the update is supposed to do I bet we can make this run WAY faster than you ever though possible. I am talking a few seconds instead of a couple hours. 🙂

Please take a few minutes and read the first article in my signature for best practices when posting questions.