Working with one of my colleagues earlier today, we found that we needed a way to store the results of a stored procedure execution in a table. He found this helpful blog post that shows exactly how.
One thing we found that the original blog post didn’t mention is that this approach works with table variables as well. A revised example that uses a table variable is available as a gist on GitHub.