October 31, 2009 at 12:25 am
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
October 31, 2009 at 12:47 am
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.
November 17, 2009 at 9:01 am
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?
November 18, 2009 at 12:28 am
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