s1shoaib
Last Activity: Apr 22 '20, 06:29 PM
Joined: Mar 31 '20
Location:
-
Updating data to another server, by linking it
What would the query look like if I want to update data to another server, it has been linked already. Using a sub query once it runs I want that data to be moving over to the other server. Also this will involve multiple columns. -
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]=... -
Backing up Data Daily in Another Server
The data would be updated daily in the other server. I have stored my query in the temp table and it is pulling from there, this is the table name: #TEMP_TBALE_TES T. Below is my query
(This is the database, table name in another server, which I want the data to be updating in daily)Code:[B]UPDATE [RTA02232Fleet].[wci].[POLog][/B]
Code:[B]SET[/B]
...Code:[B][RTA02232Fleet].[wci].[POLog].[YearMonth] = #TEMP_TBALE_TEST.[YearMonth][/B]
-
Moving data to another server
Created a query in server A to populate data for columns C,D,E. Now I want to move information for those columns C,D,E in another database in server B. I have already linked the servers.
No activity results to display