InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 02:13:18 GMT20http://www.sqlservercentral.com/Forums/Topic410392-867-1.aspxEve, as far as I'm concerned, your method here is the holy grail to me. I have been looking for a way to update or insert from one table to another, and have tried to write something myself that doesn't use a cursor and doesn't take forever to execute for weeks now. I finally entered the correct search phrase into Google search today and discovered your post. Within a few minutes I modified it to work on my main table of 7 million + records being updated or inserted into from my new table of 200,000 + records. What took over 40 minutes to do with a cursor method now takes 1 minute, 37 seconds to execute. I am elated and want to thank you very much for making my day.Wed, 02 Dec 2009 13:06:19 GMTjrichards-1056176http://www.sqlservercentral.com/Forums/Topic410392-867-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Miscellaneous/30291/">Quick update/insert into one table from another</A>[/B]Sat, 13 Oct 2007 15:04:40 GMTEve