468,306 Members | 1,265 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

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_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
0 1245

Post your reply

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

Similar topics

reply views Thread by someone | last post: by
10 posts views Thread by Lyle Fairfield | last post: by
1 post views Thread by zPaul | last post: by
6 posts views Thread by someone | last post: by
reply views Thread by pintu | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by Teichintx | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.