Tools (SSMS, Agent, Profiler, Migration, etc.)
Provide a new SSMS save-as menu option.
Provide TSQL syntax to specify a destination table (or tables for multiple recordset results).
Support designating the table as being on a different instance than the instance the query is running on.
For Central Mangement Servers, support designating the table as being on the CMS instance and including the additional column(s) added by the multi-server collection logic.
Save DBAs as great deal of time doing mundane tasks that distract them from their core responsibilities.