Loading

Table updating many records from one table to anther table2

P Narasimha

14y2.1k

Hi All,

Can you please help me on this anybody.

In side SP,

I have one Table T1 have many columns and many records, from this data insert into anther table T2 while inserting into Table T2 I need to check ID is exist or not if its exist do the updating with many records or do inserting data.

Please help me on this.

Advanced thank you.

Regards,

Narasimha

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Krishna Garad14y ago
you may try

if not exists(select id from T2 where id =(Id From T1))
do insert
else
do update