Hi,
I am carrying out some analysis of legecy stored procedures.
They are quite large. Some are 1000 lines of code.
The question I am raising here is to do with result sets.
There are many many selects with in the SP.
Some are are used to initialisze local variables
Some are selects gathering data needed for ulimate objective.
while others are the actual result sets used by the calling C
function.
My question is if there are 10 selects in an SP will there be ten
result sets ?
