>I have to two procedures, say Proc1 and Proc2. Proc1 wants to use a Cursor, but wants the Cursor populated from a result recordset produced by Proc2. Can this be done?
Use a global temporary table.
Proc2
select * into ##tmptable from mytable
Proc1
select * from ##tmptable
drop table ##tmptable
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao