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 |
|
tbensonwest
Starting Member
1 Post |
 Posted - 2009-05-18 : 09:53:19
|
| Hi,I am trying to populate a table using an update trigger so that when a members payment status changes to 'Expelled' or 'Resigned' it will insert that record into the new table. This is so that I can track the amount of members that leave our organisation in a given month.Ideally it would be nice to have the old value and new value populated in the new table but it is not a must have.The fields I want are held in the accservcategory table and are accountid(PK), paymentstatus, paymentstatuschangedate.Could anyone provide me with the syntax for the trigger?Thanks in advance...Tarran |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-05-18 : 10:19:40
|
quote:
This is so that I can track the amount of members that leave our organisation in a given month
Isn't just a simple flag or status and a date column on when the members left in the original table sufficient to provide you the required information ? Rather than a new table
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
|
|
|
Populating another table via update trigger