Resultset from SP into table

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



Hello

I have a sp where the last statement is a "select * from...."

Now can I capture this resultset that is returned, into a table ?
(without modifying the sp itself)

Something like this ? (this obviously does not work :) )
select into #ttt exec mod_pos_fx_r :)

Regards
Joe

.