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.

  • 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 Jan 7 '11 at 22:47
  • 2
    If you choose results as text you will get both result sets – waffles Jan 7 '11 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 – Some Helpful Commenter Jan 8 '11 at 0:53

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).

| improve this answer | |
  • Any idea when we should expect to see this in data.se? – Some Helpful Commenter May 15 '14 at 18:42
  • Since it's a non-trivial change it might take a little longer for Nick to review, but I can ask. – Tim Stone May 15 '14 at 18:48
  • Not sure when this went in but it's there now – Some Helpful Commenter Mar 17 '16 at 21:05

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. (contribution is welcome)

| improve this answer | |

You must log in to answer this question.

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