How to start a query execution from the result of another query?

Question

SQL

Given:
There is a large select that was previously executed by hand, as a result it produces a set of lines that were enough to insert into the console and start execution (lines like exec xp_cmdshell 'BCP "..."')
Needed:
Actually, as the resulting canvas from exec 'ov run for execution immediately after the select, without copying it to the studio console?
I can write the results of the select to a live\tempo table.
Tried to do through the cursor, but unsuccessfully.
The entire result of the select can be run line by line or all at once, it does not matter

Answer 1

Suddenly, someone needs to
declare commands cursor for
SELECT * from table_name
declare cmd varchar(max)
open commands
fetch next from commands into @cmd
while @@FETCH_STATUS=0
begin
exec (@cmd)
fetch next from commands into @cmd
end
close
deallocate commands

Answer 2

Temporary table .