I have a stored procedure within MS SQL which runs a program. I would like to, from within SQL, call this stored procedure a few hundred times but I do not want to wait for instance 1 to finish ...

How to Create a Table From Query Results in Microsoft SQL. If your business uses relational databases to store data, you may have used a SQL SELECT clause to create new tables from query results.