Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
znwpta
Starting Member
12 Posts |
 Posted - 2009-10-05 : 10:07:35
|
| Hi, I was wondering if someone had any ideas for what the best practice for the following is. Currently I have this happening when a user tries to ship products out of our system (which can be up to thousands of line items) The system uses ASP. 1- call store procedure that creates header of shipment in header table, returns table ID 2- for every line item in the page (using request forms with a lot) i call another store procedure sending productcode, lot, qty, physical location, and the unique id for the shipment header. This seems to work 99% of the time, however it is fairly time consuming to call stored procedures left and right and occasionaly we get a funky(pardon my techinical term) time out from SQL, or even if there is an sql error while processing the page, rolling back only rolls back the last line item, and not the whole shipment process. i was wondering if anyone had any sugestions to improve this process?Thanks for all the help.Anddre |
|
|
rohitkumar
Constraint Violating Yak Guru
472 Posts |
Posted - 2009-10-05 : 10:14:25
|
| how about sending xml data in step 2? that would require just one call to your second SP. |
 |
|
|
|
|
|
Header + Items Shipment