Backing up Data Daily in Another Server

[s1shoaib]

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

 UPDATE [RTA02232Fleet].[wci].[POLog]

(This is the database, table name in another server, which I want the data to be updating in daily)

 SET

 [RTA02232Fleet].[wci].[POLog].[YearMonth] = #TEMP_TBALE_TEST.[YearMonth]

 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?