Thanks for your response Gail!

We have moved it from inline SQL to a stored proc which seems to be doing the job. Would you recommend referring to the passing...