|
I am trying to write an update trigger that will send one field from one table (header) to update one field in another table (multiple rows though). Here is what I have so far, the syntax is accepted, but I get an error on the front end of the software. Any ideas are appreciated.
Thanks,
Ryan
CREATE TRIGGER UPDATEUPR00400 ON [dbo].[UPR00100]
FOR UPDATE
AS
/*
11/21/2006
The master table is UPR00100 and the field in question is WRKRCOMP.
When this value is changed, they want to update all records in UPR00400 for the same employee. The field to update in the UPR00400 table is WRKRCOMP.
The condition is that UPR00400.WRKRCOMP is not blank and it is different from UPR00100.WRKRCOMP.
*/
insert into upr00400.wrkrcomp
select a.wrkrcomp
FROM UPR00100 a INNER JOIN update i ON a.employid = i.employid
Go
| 
