SQL 2008 Linked Table UPDATE with INNER JOIN syntax help.
Posted on 2010-09-23
I am trying to update a Linked Server table with the following query but have varying errors.
Please let me know what the heck I am doing wrong here. Because it is a linked server, the tables initially need to be called out in Four Dot notation.
UPDATE [VANTAGE TEST].[MFGSYS].[PUB].[PartPlant]
SET DaysOfSupply = 10
FROM(SELECT DaysOfSupply FROM [VANTAGE TEST].[MFGSYS].[PUB].[PartPlant]
INNER JOIN [VANTAGE TEST].[MFGSYS].[PUB].[Part]
ON PartPlant.PartNum = Part.PartNum WHERE Part.TypeCode ="P")
Goal: Update the PartPlant.DaysOfSupply with a value of 10. I get errors like Cannot update VarChar field with Integer, but when I try to put the value of 10 in quotes I get other errors.
Thanks for any help!