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 - 2005-04-07 : 08:05:15
|
| dennis writes "Help please.I have TABLE A with FIELD status Status (value) : approve, on-hold, process, cancelI have to generate a report which will show the flow of status of transaction, let say the output is: TRANSACT1 approve - cancel (approve then the transaction is cancel)step I take:1. I created views that will be use for generating report.2 I will create trigger in table A so that if there are update or change in status field, I can change the value of status field in my views.my problem is: how can i get the old value of status field in table A, since if there are updates, the value that will pass to my view is the new one.can i get some of ur idea?thanks." |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2005-04-07 : 09:03:23
|
| If you're using a trigger then you should be able to use the deleted table within your trigger to reference the old value.-------Moo. :) |
 |
|
|
|
|
|
data log