View Full Version : stored procs - combining multiple selects into one?

Nov 27th, 2005, 01:42 PM
at the moment i have a stored procedure that has a while loop in it, each itteration needs to return some results (all single row things) so i essentially have a lot of select statements running on their own. this is fine in query analyser as i can easily see each of the results but my application can only see the first set of results (i think, if anyone knows how to view more sets of results in asp/asp.net please tell me) anyway.. is there a way to create some kind of master select statement and each of these just adds to it, so when it returns the select there is just one set of results?