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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-04-15 : 07:46:46
|
| Sandy writes "I have a sp which when it enters a record also enters a position for retrivaldata order-------------cat 2dog 1pig 4cow 3the sp would enter fish 3 and re-number 3 and above by adding 1 to orderdata order-------------cat 2dog 1pig 5cow 4fish 3this sp is call 3 time from the asp page (user can enter 3 records at a time)sometimes the numbering goes out of sync (about once in every 30)Could this be due to sp being run concurrently and is there any way to stop it doing this?" |
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2003-04-15 : 10:12:01
|
Can you post your stored procedure  .Sekar~~~~Success is not a destination that you ever reach. Success is the quality of your journey. |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-04-15 : 10:21:16
|
What determines that they are "in synch"?quote:
sometimes the numbering goes out of sync (about once in every 30)
Can you explain the true business problem, or is this just an exercise. It's hard to see when you're talking about cats and dogs and the order (artificially) the belong in.Brett8-) |
|
|
|
|
|
|
Stored Procedures running concurrently