Hi Bill,
I'm glad that it works for you.
>Yep, thanks Sergey. Tried it and works great. Eliminated the global temp tables. Showed it to a couple of other developers here and they thought it was really useful too.
>
>If I get a chance, I'm revisiting the possibility of extracting the necessary data using set queries but I'm dubious with the current DB structures.
>
--sb--