Recursive Triggers
-
Hey all, just for giggles, I was trying to figure out how these works. I created the following table:
Create Table Emps( EmployeeID int identity(1,1), EmpName varchar(100), ManagerID int, ActiveFlag char(1) )insert into emps(empname)values('Big Boss') insert into emps(empname, managerid)values('David', 1) insert into emps(empname, managerid)values('Holly', 2) insert into emps(empname, managerid)values('Samwell', 3) insert into emps(empname, managerid)values('Ian', 4)-- set everyone active update emps set activeflag = 'Y'CREATE TRIGGER EmpTrig ON emps For UPDATE AS UPDATE Emps SET ActiveFlag= i.activeflag FROM (Emps e INNER JOIN Inserted i ON e.managerid = i.employeeid) GOThe idea was that this would set everyone in a heirarchy "Inactive" if the manager was set inactive. Unfortunately, it does this only one level deep. How can I enable recursive triggers? Thanks in advance - *->>Always working on my game, teach me *->>something new. cout << "dav1d\n"; -
Hey all, just for giggles, I was trying to figure out how these works. I created the following table:
Create Table Emps( EmployeeID int identity(1,1), EmpName varchar(100), ManagerID int, ActiveFlag char(1) )insert into emps(empname)values('Big Boss') insert into emps(empname, managerid)values('David', 1) insert into emps(empname, managerid)values('Holly', 2) insert into emps(empname, managerid)values('Samwell', 3) insert into emps(empname, managerid)values('Ian', 4)-- set everyone active update emps set activeflag = 'Y'CREATE TRIGGER EmpTrig ON emps For UPDATE AS UPDATE Emps SET ActiveFlag= i.activeflag FROM (Emps e INNER JOIN Inserted i ON e.managerid = i.employeeid) GOThe idea was that this would set everyone in a heirarchy "Inactive" if the manager was set inactive. Unfortunately, it does this only one level deep. How can I enable recursive triggers? Thanks in advance - *->>Always working on my game, teach me *->>something new. cout << "dav1d\n";