Thanks for the response.

1. I will compare 2 columns, ProductName and StoreName. Both table have equal number of fields with same names.

2. Can't provide all fields, there are almost 35 fields in table. but you can assume it simple Products table, with 5/6 fields. ID,ProductName,StoreName,Price,ImageURL

3. for insert, it is simple, I will insert all rows from "temptable" to "OrginialTable" which not exists in "originaltable". code is at

http://www.sqlservercentral.com/Forums/Topic503363-8-1.aspx

Insert is only 1 line query. but for update, I am not sure, I will be able to do in 1 line. I am afraid, I will need to use Cursors. But waiting for more good solutions.

Hope these are enough details, still if you need, please let me know.

Regards,

Azam.