Well I had to put results from an SP into a table and here is how I did it:
DECLARE @RC int
INSERT INTO [Database].[dbo].Table_to_Insert_Into ( SP_Column1 , SP_Column2)
EXECUTE @RC = [Database].[dbo].[Sp_to_Run]
This is assuming the stored procedure returns two columns (1 or more rows) and Passing a parameter.
Hope this helps...