I am trying to update a value on a field in a SQL SERVER table from a function that exists in a Linked Server.
I have tried using the syntax below, but I get this error: Incorrect syntax near the keyword 'SELECT'.
UPDATE [dbo].[ORDER] set [OrderDescription] = SELECT * FROM OPENQUERY([SERVER2], 'Select [Database2].[dbo].[GetMarket]('ABC')
What do I have to do to fix this?
Thanks in advance,