Hi Dave,

Thankyou very much for your script, I am almost looking for the similar kind of script, with little modification it works perfectly for me.

I appriciate your help.

Charlie

If you are trying to populate into another table the seqn number, select the seqn number directly from the deleted table into the table to which you are inserting.

insert into...

Before inserting the next record try to check in the table if it already exists,if it exists then don't insert otherwise insert the record.

I don't have the data with me,I have to generate it when the data is passed into the script. I am using @a, @b-2 and

I don't have the data with me,I have to generate it when the data is passed into the script. I am using @a, @b-2 and

I would have a 2 step approach, Insert all the records into a temp table. Alter the table to include the identity column and insert the records into the table...