[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