[thelist] SQL: Using recordsets from nested store procedures

listman at hazard0us.org listman at hazard0us.org
Sat Nov 9 02:40:02 CST 2002


If your outer procedure is SP1
and the inner procedure is SP2 ,
you can use the following syntax :

<code>
create procedure SP1
as
begin

--your code here

insert into tmpTable
Exec SP2

end
</code>

you will just need to make sure that the columns returned by SP2 map
correctly to the field names in tmpTable

HTH
ashok






More information about the thelist mailing list