Hi,

Thanks for the replies. I did with global temporary table.

Any how the SP will execute only once and as a job.

So, global temporary table is fair enough.

thanks again for the replies.

cheers