What’s worked really well for our small development team is having a development DBA as a part of the development team. Complex queries, stored procedures, etc are developed by DBA....

Went about it in a completely different fashion and solved it.

Note, EXEC <stmt> AT far_server didn't yield what was needed. Had to make dynamic sql with OPENQUERY.

Have you tried:

Update employees

SET ID = e.EXTENDEDID

FROM employees e

WHERE ID <> e.EXTENDEDID

Did you ever get a resolution for this? I'm having the same issue on the same platform (Windows 7, Visual Studio 2008).

Ray,

Using an expression instead of direct input worked. Thanks for the tip!:-)

Full solution that worked for me

SELECT

*

FROM

(

SELECT *

...

Thanks! That's what I needed.

Thanks! I knew it would be something simple.

UPDATE ADDRESS

SET ADDRESS_STATE_ID = s.STATE_ID

FROM zipcode z

INNER JOIN state_ref s

ON s.STATE_ABBREV =...