get resulset from stored procedure

Hi all!
I have one stored procedure than returns a resulset (select). I want to
execute this in other stored procedure and get the resulset... How can i
get it?
TIA
Alfonsohttp://www.sommarskog.se/share_data.html
David Portas
SQL Server MVP
--|||Hi,
CREATE TABLE #TEMP
(
COL1 INT NOT NULL
)
INSERT INTO #TEMP EXEC SP
Also seen on:
http://groups.google.de/groups?hl=d...r />
40phx.gbl
%26rnum%3D8
HTH, Jens Smeyer
http://www.sqlserver2005.de
--
"Alfonso" <aNOSPAMparedes@.rtspain.com> schrieb im Newsbeitrag
news:%234DizOAQFHA.244@.TK2MSFTNGP12.phx.gbl...
> Hi all!
> I have one stored procedure than returns a resulset (select). I want to
> execute this in other stored procedure and get the resulset... How can i
> get it?
> TIA
> Alfonso
>|||
Thanks David & Jens for your answers
I got it :-)))