We’ve just been handed an ad-hoc request for information which will require us to run a bunch of queries against a summary of last year's sales figures. What is the best choice for this situation?
Derived Table
Volatile Table
Global Temp Table
All of the above