PDA

View Full Version : Conditional Insert Query Based on Data in Target Table



Transformer
06-23-2013, 04:24 PM
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?host=usefulgyaan.wordpress.com&blog=50473542 &post=1078&subd=usefulgyaan&ref=&feed=1

Conditional Insert Query Based on Data in Target Table (http://usefulgyaan.wordpress.com/2013/06/23/conditional-insert-query-based-on-data-in-target-table/)