470,569 Members | 2,188 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,569 developers. It's quick & easy.

The multi-part identifier could not be bound

Trying to update data from one server to the server. There are 3 columns: Year, Site and Code that need to be updated from my current server to Server2, however I keep on getting the error of "The multi-part identifier could not be bound." Below is my query:

[code]UPDATE [Server2].[Fleet].[dbo].[log]

[Server2].[Fleet].[dbo].[log].[Year]= Poll.[Year],
[Server2].[Fleet].[dbo].[log].[Site]= Poll.[Site],
[Server2].[Fleet].[dbo].[log].[code]= Poll.
Expand|Select|Wrap|Line Numbers
  2. FROM(SELECT Year, 
  3. Site, 
  4. Code
  6. FROM sacfindb.[UC_POLog].[dbo].[ctbl.Main.Report]
  8. WHERE Year = left(convert(varchar,getdate(),126),7)
  9.       AND Site = '7115'
  10.       and Code in (
  11.       '52120','52140','52147','52146','52182'
  12.       )) Poll
Apr 8 '20 #1
0 2527

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

34 posts views Thread by Niels Berkers | last post: by
12 posts views Thread by Russell E. Owen | last post: by
7 posts views Thread by Mark Waser | last post: by
2 posts views Thread by gezerpunta | last post: by
1 post views Thread by Wingot | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.