sp

[site]

Hi,

Can I do this way:

select name from (execute sp_student). I really want to get this field from sp.

Many Thanks.

Jing

 

[tlbroadbent]

No, unfortunately you can't. You can create a temporary table and insert the output of teh stored proc into the table. Then select the record(s) form the table.

/* modify to match the output of the SP */
create table #t (ColStudent varchar(40))

insert #t
exec sp_student

select * from #t

Drop table #t Terry Broadbent

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin