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