Andy - if I understand it correctly, you said a stored proc has the advantage of having its query plan stored and reused without the need for recompile. Implicitely it...

Thanks for being open and upfront and not sweeping it under the rug. Much appreciated.

unfortunately its not my proc so I'm not sure. I will ask my collegue to try it with a profile and see where that gets us. I suppose another approach...