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

Backing up Data Daily in Another Server

P: 4
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_TEST. Below is my query

Expand|Select|Wrap|Line Numbers
  1.  UPDATE [RTA02232Fleet].[wci].[POLog]
(This is the database, table name in another server, which I want the data to be updating in daily)

Expand|Select|Wrap|Line Numbers
  1.  SET
Expand|Select|Wrap|Line Numbers
  1.  [RTA02232Fleet].[wci].[POLog].[YearMonth] = #TEMP_TBALE_TEST.[YearMonth]
Expand|Select|Wrap|Line Numbers
  1.  FROM (SELECT * FROM #TEMP_TBALE_TEST)
(This is the select query used which executes fine)

So basically using the update query with a select statement in it, is what I have, could this work?
Mar 31 '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.