Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
11-27-2005, 12:42 PM #1
- Join Date
- Apr 2003
- Thanked 13 Times in 13 Posts
stored procs - combining multiple selects into one?
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?