The earlier solution works perfectly in updating the table but when I run it for over 10,000 lines it stops after doing a few hundred updates. I recieve the following error: "The timeout period elapsed prior to completion of the operation or the server is not responding."
Is this due to the opening of connections over and over? Is there any way to fix it? Is there a more efficient way to do this? If not I can do the update in smaller batches. I was just wondering if I was doing something wrong.