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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Need Help with Trigger

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
Defendent2
Defendant3

tblCaseBillingDetails
Fields
DefCount

I 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 MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
   

- Advertisement -