"more than the maximum number of prefixes"

[LeonAtRC]

I'm trying to update records in a table on a remote server but I keep getting an error about too many prefixed in the WHERE clause.

UPDATE RemSVR.RemDB.dbo.People 
	SET OfficeID = Corporate.OfficeNMBR
	FROM Corporate
	[COLOR=blue]WHERE RemSVR.RemDB.dbo.People.OfficeFloor[/color] = Corporate.OfficeFloor

Can someone figure a work-around?
Thanks

 

[gmmastros]

This is where table aliases come in VERY handy.

UPDATE [!]People[/!]
SET    OfficeID = Corporate.OfficeNMBR
FROM   RemSVR.RemDB.dbo.People As [!]People[/!]
       Inner Join Corporate
         On [!]People[/!].OfficeFloor = Corporate.OfficeFloor

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[LeonAtRC]

Great!
Thanks for the quick reply.