proc's result set to a temporary table.

proc's result set to a temporary table.

 

  

Is it possible to have result set of stored procedure into temporary table?
OR
If I need only one column of the whole result set returned by a stored procedure how can I have it?

Provided, of course, that altering or recreating the stored procedure is not an option.

Thank you in advance,
Yuriy

MS Sql Server LazyDBA home page