Conditional Insert Query Based on Data in Target Table

UsefulGyaan Has Posted the Following On 06-23-2013 04:49 PM:

Problem Statement: There is a table named Employee which has department wise employee details as given below. We want to insert some new records in this table but a record should not be inserted if it is already there in the table. Dept Employee_ID Gender IT E123 M IT E124 M IT E125 M IT E126 […]http://stats.wordpress.com/b.gif?hos...f=&feed=1

Conditional Insert Query Based on Data in Target Table