Topic: Question on outswapping
With new 2018!
Assume I wrote a SQL query which consists of two parts. The first part of request preempts such given as shipments, sales, resets on days for the last 60 days. Plus still some reference tables. The second part of request does difficult calculation of this data. The second part of request is adjusted, as the request on the certain logic is not added still. In test basis I can write and launch requests. If the request is ready, I give to its employee who has rights to outswapping from working basis. As the second part of request is adjusted, permanently it is necessary to launch anew from working basis.
Whether probably to make so that the data of working basis were preempted, saved, and then in test basis to obtain this data and then to launch the second part of request? There can be what a function special there is for these purposes in the program of SQL Server Management Studio, or what a utility, or what that another?