Thanks everyone for the replies...I could not see around this corner. This is the logic I was looking for..

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...

How would I be able to similarly do this as a trigger.

Thank You... I do not know why my other expected solution did not work for this...I really beat my head against a rock on this one... but I understand the...

I want to update the history record if a update has occured. (I have two tables. One emp and the other emphistory. When the empname or Deptid field updates in...

Here is my final lunge at this problem... I would like to think im going in the right direction....

--b.Trigger 2 – Build a tirgger on the emp table after an...

Yes...it is home work... My real question is actually can the following question be answered with the attached data. I feel that the question has a flaw to it....what...