OPENQUERY UPDATE Syntax help needed

Hi All

I am updating a local table based on inner join between local table
and remote table.

Update LocalTable
SET Field1 = B.Field1
FROM LinkedServer.dbname.dbo.RemoteTable B
INNER JOIN LocalTable A
ON B.Field2 = A.Field2
AND B.Field3 = A.Field3

This query takes 18 minutes to run.
I am hoping to speed up the process by writing in OPENQUERY syntax.

Thanks
RS

.

Relevant Pages

  • Remote table hint example needed for simple join
    ... table is being joined to table on a linked server and the select needs ... to run on the remote table. ... FROM Books INNER JOIN BookOrders ON Books.TitleID = BookOrders.TitleID ... server using the remote table hint. ...
    (microsoft.public.sqlserver.programming)
  • Re: Update external database
    ... > Thank you for yoru reply, unfortunately I believe I might not have ... >But when I run this I get a syntax error and it points to 'INNER JOIN'. ... to update the local table instead of the remote table. ...
    (microsoft.public.access.queries)
  • Re: driving_site and local function call
    ... Therefore hint DRIVING_SITE is used to make the query happen on the ... inner join table2@remotedb on ... when the function call is uncommented the query is happening locally. ... evaluated at the remote db, so Oracle has to transfer the working set ...
    (comp.databases.oracle.server)
  • Remote view sql designer being too clever
    ... INNER JOIN dbo.ORDER_MSTR Order_mstr; ... however if I try and modify fields with the remote view designer under ... always regenerate the sql into ...
    (microsoft.public.fox.programmer.exchange)
  • OPENQUERY UPDATE Syntax help needed
    ... I am updating a local table based on inner join between local table ... and remote table. ... SET Field1 = B.Field1 ...
    (comp.databases.ms-sqlserver)