Thanks NetWallah, but I should have mentioned that the multiple selects in my example were just for brevity. I am actually executing a Stored Procedure that generates multiple output sets. The solution suggested by poj displays all the output sets.
"It's not how hard you work, it's how much you get done."