data-konzept

'There are times when you might what to execute a stored procedure where you want the output of the stored procedure to go into a table, instead of having the output display across the screen. Putting the output in a table provides you multiple options for parsing and using the output with other TSQL commands. In this tip I will show you an easy way to get the output of a stored procedure into a table.'...

http://www.databasejournal.com/features/mssql/how-to-get-the-output-of-a-stored-procedure-into-a-table.html