At 05:15 PM 9/12/2002 -0400, Bill Meaney wrote:

>Can I
>
>DECLARE cCurs CURSOR FOR <select>;

Nope. What I would try - and I think it will work -
is to create three procedures: a driver (D) and two
loopers (L1, L2).

while (a = 1)
begin
select (x,y,z) from L1
select (a,b,c) from L2
whatever...
end

You'll put in appropriate logic to break out of the
loop when you've hit eof.



Regards,

Ann
www.ibphoenix.com
We have answers.