i have 2 tables.at the end of each day,data from table 1 gets deleted from it and get inserted into table2(using trigger)
how to ensure that no duplicate data gets inserted into table2?

hi,

Use a Primary Key Foriegn Key relation using some identity field in table1. Now while inserting use outer join to the table2 and insert only non matching ones, ie foriegn key in Table2 is null (OR a not in if only few recs)

Prashant

i need a trigger itself so that while inserting ,it can check for duplicate records