Welcome to SSC. Thanks for the CREATE TABLE and INSERT scripts... they're easier to use if you post them this way, though:

CREATE TABLE Employee(

EmployeeID INT PRIMARY KEY,

EmployeeName VARCHAR(20) NOT NULL,

DeptID INT);

GO

INSERT INTO Employee VALUES(333,'Ali',653);

INSERT INTO Employee VALUES(243,'Joe',23455);

INSERT INTO Employee VALUES(222,'Steve',78);

INSERT INTO Employee VALUES(433,'Markj',75);

INSERT INTO Employee VALUES(322,'Dale',45);

INSERT INTO Employee VALUES(432,'Stephanie',70);

INSERT INTO Employee VALUES(777,'Kent',745);

INSERT INTO Employee VALUES(122,'Julius',25);

INSERT INTO Employee VALUES(233,'Tovarus',97);

INSERT INTO Employee VALUES(111,'Flint',6);

INSERT INTO Employee VALUES(133,'Mosbacker',332);

INSERT INTO Employee VALUES(2121,'Davidsion',1333);

INSERT INTO Employee VALUES(2221,'SHEGOZIY',1776);

CREATE TABLE EmployeeHISTORY(EmployeeIDINT

,DeptIDINT

,IsActive BIT);

GO

INSERT INTO EmployeeHISTORY VALUES(333,653, 1);

INSERT INTO EmployeeHISTORY VALUES(243,232,1);

INSERT INTO EmployeeHISTORY VALUES(222,78,1);

INSERT INTO EmployeeHISTORY VALUES(433,75,1);

INSERT INTO EmployeeHISTORY VALUES(322,45,1);

INSERT INTO EmployeeHISTORY VALUES(432,70,1);

INSERT INTO EmployeeHISTORY VALUES(777,745,1);

INSERT INTO EmployeeHISTORY VALUES(122,25,1);

INSERT INTO EmployeeHISTORY VALUES(233,97,1);

INSERT INTO EmployeeHISTORY VALUES(111,6,1);

INSERT INTO EmployeeHISTORY VALUES(133,332,1);

INSERT INTO EmployeeHISTORY VALUES(2121,1333,1);

INSERT INTO EmployeeHISTORY VALUES(2221,1776,1);

If you always want to delete the EmployeeHistory records of an Employee when the Employee is deleted, you can just create a foreign key constraint on the EmployeeHistory table and use ON DELETE CASCADE.

CREATE TABLE EmployeeHistory

(

EmployeeIDINT

,DeptIDINT

,IsActive BIT)

CONSTRAINT fk_EmployeeID

FOREIGN KEY (EmployeeID)

REFERENCES Employee (EmployeeID)

ON DELETE CASCADE

);

Then you don't have to use a trigger.