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-01-25 : 12:11:05
|
Chris writes "I have a REQUEST table that holds global information about a request. I also have a table the hold specific information about the sub-requests for the request in the REQUEST table. | Request Table: | | requestID | CustID | CustName | CustNumber | RequestStatus | | ABC-12345 | 45039 | ChrisH | 555-1234 |
| Sub-Request Table: | | RequestID | Sub-RequestID | ServiceType | ServiceStatus | | ABC-12345 | 45 | 2 | Open | | ABC-12345 | 46 | 1 | Closed | | ABC-12345 | 48 | 25 | Assigned |
What I need is a trigger on SUB-REQUEST that updates REQUEST.RequestStatus what "See Details" if related sub-requests ServiceStatus's are different and if they are the same then put that ServiceStatus in REQUEST.RequestStatus " |
|
|
|
|
|
Create a trigger on one table that updates a field on an other table