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 - 2001-11-13 : 19:23:27
|
| Bob writes "I'm not an expert in SQL so there may be a better way to do this. I have an inventory database where we store incoming equipment and then deploy it. If there is an instance where inventory comes in and it is already earmarked for someone I want it go in the database with a status of 'hold' instead of 'In-stock'. That way it does not appear as available inventory. However, if someone submits it and forgets to deploy it, I want it to switch the status to In-Stock. I tried a WAITFOR in the stored procedure but that didn't work right because the calling web page hung for the WAITFOR time period. Now I'm looking at using a trigger for implementing the WAITFOR. However, I can't figure out how to specify the record I want it to update.Any help would be appreciated. If you have a better idea of how to do it, I'm open to that as well.Thanks" |
|
|
|
|
|
Triggers and WAITFOR