This is a query for loading some survey data from our OLTP to our DataWarehouse . We create a temptable, then populate it with all data from the last 7 days in the survey table via openquery. We then are merging it.
By todd81 16 asked Aug 06, 2015 at 02:00 PM
It's difficult to be absolutely certain from the anonymized plan, but I'm almost 100% sure that query will not give you the results you are after. The
Generally speaking, it's tough to write
99 times out of 100, it's better (faster, more reliable) to write separate insert/update/delete queries. It might sound counter-intuitive, but that is my definite experience with
By SQLkiwi ♦ 6.6k answered Aug 11, 2015 at 04:05 AM