Thanks mrpolecat I'll give it a go. I think I'll run into other problems, because I want to use the select statement as part of a cursor (I've heard I...

Have you thought of using functions in your stored procedures ? I've done this before with no apparent performance hit, and it makes debugging easier.