Making SP more better

  • i written a SP for inserting PurchaseDetails which will be called number of times from my application.

    for example if 10 items purchased i looped it and SP called for 10 times.

    Now i'm trying to call this only one time but all the values should be sent as parameters.

    any help plz

  • karthimca07 (10/31/2009)


    for example if 10 items purchased i looped it and SP called for 10 times.

    Hi,

    Unless see your code, it’s hard to advice!, Post your code.

  • Do you want to pass all 10 items as 10 parameters to SP? Are the number of items will be 10 every time you call an SP from your application?

  • Can you clear your question and could you post your stored procedure . Without that its hard to give any suggestion.

    If you are calling the sp from the application you can also create an xml and pass that xml. It will work and the load on your server calling the sp again will be lowered.:-)

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply