Hi All,
I have an store procedure with a 100 and some lines, and I want to analize
the result from another sp.
How can I get the values to do a select statement?
create procedure myPro
As
    select * from orders bla...
go

create procedure analizemyPro
As
    declare @temp varchar(100)
    select @temp = ordername from (here the result of myPro)
Go

Tks in advance
JFB

Output parameters,look up (stored procedures, output parameters) in BOL
or create a table and do an insert with exec

insert into table
exec myPro

http://sqlservercode.blogspot.com/

Tks for you reply and help... We got it :)

Show quoteHide quote

A difficult Combining Rows problem
How to use OPENXML to retrieve detail lineitems
what is general/conventional way to reduce/prevent deadlock?
Complicated OR
Query Assistance