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)
(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?
Code:
[B]UPDATE [RTA02232Fleet].[wci].[POLog][/B]
Code:
[B]SET[/B]
Code:
[B][RTA02232Fleet].[wci].[POLog].[YearMonth] = #TEMP_TBALE_TEST.[YearMonth][/B]
Code:
[B]FROM (SELECT * FROM #TEMP_TBALE_TEST)[/B]
So basically using the update query with a select statement in it, is what I have, could this work?