By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,403 Members | 1,360 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,403 IT Pros & Developers. It's quick & easy.

The multi-part identifier could not be bound

P: 4
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
Share this question for a faster answer!
Share on Google+

Post your reply

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