6

If you run this query in Data Explorer it would appear that both queries run since the message window reads...

(1 row(s) affected)

(555 row(s) affected)

...but only the first result is displayed or exported (download results).

It would be nice if all result sets where displayed and exported. Or at least exported.

If N number of result sets seems like asking for trouble, perhaps a limit > 1 would be acceptable.

3
  • Good idea. Given that you can run any number of query windows right now, it's probably fine to just limit the number of multi-results to something sane like 5. I doubt a lot of people will be using this.
    – Jon Seigel
    Commented Jan 7, 2011 at 22:47
  • 2
    If you choose results as text you will get both result sets
    – waffles
    Commented Jan 7, 2011 at 23:11
  • @waffles nice. not as a cool as if there was full support but since it's a bit of a corner case and probably not in high demand I would certainly accept it if it was given as an answer Commented Jan 8, 2011 at 0:53

2 Answers 2

4

The result of this fairly lengthy list of commits is that you will now be able to get multiple result sets back and have them be rendered by Slick Grid, with the ability to toggle between them:

result set toggle

Per the pull request description, a number of related issues are fixed. This includes unexpected triggering of the graphing code crashing the browser tab, the grids having an inconsistent style from the rest of the site, and a problem with sorting magic columns (and not knowing that the columns were sortable in the first place).

0
2

If you choose results as text you will get both result sets.

I am not against adding support for multiple grids. It is, however, a fairly complex change (contributions are welcome).

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .