Expand|Select|Wrap|Line Numbers
- UPDATE [RTA02232Fleet].[wci].[POLog]
Expand|Select|Wrap|Line Numbers
- SET
Expand|Select|Wrap|Line Numbers
- [RTA02232Fleet].[wci].[POLog].[YearMonth] = #TEMP_TBALE_TEST.[YearMonth]
Expand|Select|Wrap|Line Numbers
- FROM (SELECT * FROM #TEMP_TBALE_TEST)
So basically using the update query with a select statement in it, is what I have, could this work?