Hey, thank u for the respond.

Yes we usually append records into that table(tblModels) on a daily basis as we do receive more than 50 000 records and duplicates records are included there,we want that to allow only unique records.

That table is actually using by different teams including our local call centers.What i need is the solution to maintain this table by not including duplicate records in order for other team member who is responsible for correcting new rocords according to our business rules. Because if we have duplicates within that table,size will grow dramatically, more work will be assigned to him to correct even the same records we've received before and which will delay our process and timing.

Please assist.