In a stored proc, if I have a loop and inside the loop do a select, every
select will be returned as a seperate result set. How can I combine all of
the result sets into one, or better yet, keep selecting into the same result
This will result in 10 result sets. But I'd like 10 rows in a single result
set. Any ideas?
With your solution in mind, what will happens in the case when one of the
result sets from above doesn't result in any rows, but others do?