Ed,

Thanks for your reply, I think you're correct on all points.

From everyone's feedback so far it looks like what we have at the moment could well be the best solution, but we definitely need to look at re-factoring some of our hideous dynamic SQL.

Regards,

Darren