set rs=con.execute("exec procname")
if not (rs.nextrecordset is nothing) then
set rs1=rs.nextrecordset
end if...
if not (rs.nextrecordset is nothing) then
set rs1=rs.nextrecordset
end if...
select * from 表名2