If you have a stored procedure that returns a dataset, you can insert that data directly into a table.
First, you need to create target table and define columns. Columns need to match the dataset your stored procedure is returning. So for example if your stored procedure returns a dataset that contains integer field followed by two nvarchar(50) fields, target table would look like:
CREATE TABLE #MyTable ( Col1 int, Col2 nvarchar(50), Col3 nvarchar(50) )
When you’ve defined the table, insert the data by calling your stored procedure:
INSERT INTO #MyTable EXEC spxMySP @Params