Insert rows in a table if they are not found in another table

Question

I have a table:

Employee (employeeID) EmployeeRank (rankID, employeeID) 

Now I have one more table in which there are all employees who are going to get a promotion.

 DueForRaise (rankID, employeeID) 

I need to insert all the employees who are in DUeForRaise into the EmployeeRank table ONLY if they do not already exist with the same rank.

I am doing this update for the rankID parameter, @rankID.

Will this work?

 INSERT EmployeeRank ( rankID, employeeID) SELECT rankID, employeeID FROM DueForRaise dfr OUTER JOIN EmployeeRank er er.employeeid = dfr.employeeid) WHERE dfr.rankID = @rankID 

Answer 1

What about:

 insert into EmployeeRank select * from DueForRaise p where NOT EXISTS( SELECT * FROM EmployeeRank WHERE rankID=p.rankID and employeeID=p.employeeID ); 

Answer 2

IF NOT EXISTING (SELECT * FROM EmployeeRank WHERE rankID = @rankID AND employeeID = @employeeID)

INSERT INTO EmployeeRank (rankID, employeeID) VALUES (@rankID, @employeeID)