Forgot to mention - when I execute the procedure and pass an appropriate parameter to it, the query executes successfully but with no results and I get the following messages...

Thank you for your help everyone. I'm please to say I cracked it in the end.