Get Results of Stored Procedure and insert to temp table

I needed to get the storage results recently of a bunch of SQL tables.   Here's how I did it.


1) Create a temporary Table


CREATE TABLE #spaceused (
nameout VARCHAR(50)
,rowsout int
,reservedout VARCHAR(50)
,dataout VARCHAR(50)
,index_sizeout VARCHAR(50)
,unusedout VARCHAR(50)
)


2) Send the results to the table, using sp_spaceused 

I also created a script to generate about 100 of these INSERTs

INSERT INTO #spaceused EXEC sp_spaceused N'TableName' ;
GO


3) Query the results...

SELECT TOP 10 * FROM #spaceused


4) Delete the temp table when done. 


DROP TABLE #spaceused