Insert Values of Stored Procedure in Table – Use Table Valued Function

I recently got many emails requesting to write a simple article. I also got a request to explain different ways to insert the values from a stored procedure into a table. Let us quickly look at the conventional way of doing the same. Please note that this only works with the stored procedure with only one resultset. Let us create a stored procedure that returns one resultset.