if you know the shape of the data being output from the procedure, you can insert it directly into a table;
for example, if your proc returns a single column table of CREATE LOGIn statments:
CREATE TABLE #Results(ResultsID int identity(1,1) NOT NULL Primary Key, ResultsText varchar(2000) )
INSERT INTO Results(ResultsText )
EXECUTE MyProcedure @parameter = 42
will that help?
Lowell