Thank u so much for ur suggestion..

I done that in query window..

It took 1hr 40 min...

If it is b'coz of index

Can I recreate like this and insert the rows

alter table dbo.Total add constraint

pk_test primary key nonclustered (Email)

Pls suggest me...

I think that is left outer join instead of inner join

Hi,

Could u pls tell us detailed procedure for that as we r new to SQL SERVER..

Thnx in advance...