Inserting A Stored Procedures Results In To A Table

Just a quick post to cover somthing that I've seen cropping up a lot recently. Thats copying the results of a stored procedure in to a table.

The code below will call the stored procedure spGetRecords and copy its results into the specified table.

CREATE TABLE #tmpBus
(
   COL1 INT,
   COL2 INT   
)

INSERT INTO #tmpBus 
Exec SpGetRecords 'Params'