• A good article and an interesting approach. Another approach for when dealing with truly large amounts of data is to have the application output it into a CSV file and then import that through a procedure which uses bulk insert. Of course, that is generally not the best approach for just a few rows, but it works nicely if there are a very large number.

    ---
    Timothy A Wiseman
    SQL Blog: http://timothyawiseman.wordpress.com/