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 |
billMcMI
Starting Member
2 Posts |
Posted - 2013-10-13 : 20:30:48
|
I need help creating an update trigger that involved two tables and a few fields.tblCases Fields Defendent1 Defendent2Defendant3tblCaseBillingDetails Fields DefCountI would like to create the trigger on tblCaseBillingDetails so that when the data in the Defendant fields are updated, the trigger fires and updates the Defendant count DefCount. |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-10-14 : 01:58:18
|
So what does DefCount represent? sum of Defendent1,Defendent2,Defendant3?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
|
|