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)
- [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?
