468,307 Members | 1,339 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,307 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]

SET
[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
  1.  
  2. FROM(SELECT Year, 
  3. Site, 
  4. Code
  5.  
  6. FROM sacfindb.[UC_POLog].[dbo].[ctbl.Main.Report]
  7.  
  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 2128

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
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.