hi Serge,
for me to be able to return it as table, creating temporary table and insert it during the loop. the query the temp after the loop. do u have any better idea?