Hi Alikutty - thank you for replying.

I did mention in my question that I am familiar with the catalog table variable but the customer DOES NOT want that functionality.

I am thinking that is my best bet, but I need to convince the customer that this is the only way to achieve this.

I wanted to check with the community to see if there were any other options.

Regards,

Karen