Thank you for your reply Luis.

I dismissed the global temp table because this is something that multiple users will be doing concurrently, so for now I am going down the permanent table route and will come back to it when I have more time.

Regards,

Mark