Thanks for all the replies. Here are answers to some questions raised:

For Farrell Keough's question: Yes I do use dynamic SQL here

For Phil Parkin and Fran Kalis: To comply with...