How can I get the resultset from a stored procedure

CREATE #TABLE (
define here the column according to the SP output format
)

INSERT INTO #TABLE EXEC my_sp


Chris
--
______________________________________________
It's still better that if it would have been worst, isn't it ?
C'est toujours mieux que si c'etait pire !
"Vincent" wrote in message

 > I have a stored procedure which will output a table.
 > How can I use a sql statement to get the result of the sp?
 >
 > Thanks a lot
 >
 >

As a sample :

create table ##Test
(
SPID int,
ecid int,
status varchar(60),
loginame varchar(90),
hostname varchar (20),
blk int,
dbname varchar(30),
cmd varchar(100)
)

insert into ##test exec master.dbo.sp_who


--
______________________________________________
It's still better that if it would have been worst, isn't it ?
C'est toujours mieux que si c'etait pire !
"Vincent" wrote in message

 > I have a stored procedure which will output a table.
 > How can I use a sql statement to get the result of the sp?
 >
 > Thanks a lot
 >
 >