• It seems you are calling the procedure 5 times for the 5 rows

    You will have to change this approach and call the procedure only once and insert all the 5 rows at once.

    Do you have any staging table where you are storing these 5 rows before inserting them into the main table?

    Edit:Corrected spelling mistake.


    Kingston Dhasian

    How to post data/code on a forum to get the best help - Jeff Moden
    http://www.sqlservercentral.com/articles/Best+Practices/61537/