Hi

You can insert the result set of a procedures into a table.

Insert into table1 (col1,col2....)

Exec StoreProc1 @param1,@param2... .