question

Rashi avatar image
Rashi asked

I want to do the comparision of temp table data with the linkedserver table data .Please help me how to write the query

I am trying like: insert into openquery(linkedservername,'select * from table') select * from openquery(linkedservername,'select * from table')a ,#temp b where a.code<>b.code a.name<>b.name a.date<>b.date But When I m executing this query its taking so much time.... Please help me ...
tabletemporary-tableopenquery
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.