• Greetings Guys I decided to go ahead and post the solution I came up with.

    ALTER TRIGGER trg_mrk_inactive

    ON [dbo].[emp]

    AFTER DELETE --CREATES TRIGGER AFTER DELETE ACTION

    AS

    BEGIN

    INSERT INTO Emphistory ---WILL INSERT INTO EMPHISTORY THE DELETED VALUES SPECIFIED IN THE SELECT ADDING - ISACTIVE = 0

    SELECT D.empid, D.DEPTID, ISACTIVE = 0

    FROM DELETED AS D