Jeff Moden (10/22/2010)
Chris Morris-439714 (10/22/2010)
Heh Jeff's gonna hate me for this but I couldn't resist it.400,000 rows in 15 seconds:
Actually, I don't hate you. That's some good, solid, creative, fast code, Chris. There's just one thing... you code only displays the data. It doesn't update either table. Make it so you update one of the two tables and we'll have a drag race. 🙂
I'm not sure I see where the requirement to update the original table comes from?
If the results need to be persisted, simply change the SELECT into a SELECT INTO.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi