Inserting Stored Procedure results into Table data type

[dddenney]

I am writing a stored procedure and would like to call another stored procedure and place the results into a Table data type. I know this can be done using temp tables..

Insert #tmpTable
exec sp_StoredProcedure


But since this causes more frequent re-compiles of the stored procedure I would rather use a table data type. Does anyone know how or if this can be done?

Thanks in advance...

Dan

 

[JayKusch]

Cannot use a table variable for this purpose. Will not except an execute statement.

Thanks

J. Kusch

 

[dddenney]

I was afraid of that. I was hoping there might be some way to work around that.

Thanks anyway.