Could this be adapted to copy data to a separate database in the same instance. We perform mostly database to database copying.
Example:
SELECT my-column1, my-column2
INTO [my-2nd-database].[schema].[mytable]
FROM [my-1st-database].[schema].[mytable]