Hi John:

Have you tried using local temporary tables? Though not variables, they can store data like tables do, are active for the life of the connection, and are invisible to other connections.

HTH