Hi there, I am also trying to do something like this, but keep getting an error 42000.
My query looks like this:
UPDATE dbo.BlogCopy_copy
SET dbo.BlogCopy_copy.ProcID = dbo.BlogProcedures.ProcID
FROM dbo.BlogCopy_copy, dbo.BlogProcedures
Where dbo.BlogWebs_copy.WebID=dbo.BlogProcedures.WebID
The actual error is : [Err] 42000 - [SQL Server]The multi-part identifier "dbo.BlogWebs_copy.WebID" could not be bound.
I created a new table in BlogCopy_copy for ProcID and I need to have that populated with the same value as the "ProcID" in the table BlogProcedures.
Any help with this will be greatly appreciated.
Thanks
Hans