• What I was really hoping to see is how the final statement looks when you execute it.

    It's different if it looks like this

    INSERT INTO test(col1, col2) VALUES( @param1, @param2)

    INSERT INTO test(col1, col2) VALUES( @param1, @param2)

    INSERT INTO test(col1, col2) VALUES( @param1, @param2)

    INSERT INTO test(col1, col2) VALUES( @param1, @param2)

    INSERT INTO test(col1, col2) VALUES( @param1, @param2)

    Than if it looks like this

    INSERT INTO test(col1, col2) VALUES

    ( @param1, @param2),

    ( @param1, @param2),

    ( @param1, @param2),

    ( @param1, @param2),

    ( @param1, @param2)

    I'm not sure if I'm clear enough.

    If you're just testing, then just test, and test several times to obtain consistent results because times can vary depending on the workload of the server.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2