Toad World® Forums

Vertical stacking of result sets (no tabs) when running multiple queries

Is it possible in toad-for-sql-serverto display results from more than one query one below the other when multiple queries are selected and run. SQL Server Mgmt Studio does this and this makes for easy comparison between results from two different queries/tables. In toad-for-sql-server I can tab between multiple result sets but only view one result set at a time. Or I can have results from multiple queries in the same result set and get a sort of index column at the left which tells me the no. of rows returned from each query and I can then choose one of them to see in the result set. Either way I cannot view more than one result set or multiple results in a result set at the same time. This is insanely useful when successively building more complex queries.

I would also be very interested in this… Is ther ea thought of adding this feature?

Hi,

Thank you very much for your suggestion. I have created enhancements TSS-868. We will discuss for this and keep you update. Thanks again.

Best Regards,

Kelly

Any update onTSS-868?

I am very interested in this as well. Any status on TSS-868?

Hi,

Thanks. Toad team is working on this feature. And we are discussing add to ToadforSQLServer.

Best Regards,

Kelly

Hi,

This Feature has been added to toad now. Please try in next Beta.

We can enable it in Option - Database - Script result - Enable all results view.

Best Regards,

Kelly

I do not like the way this is implemented in Beta because you cannot filter or sort each data set individually while looking at both sets.

I would rather see two individual result set boxes with the ability to filter and scroll each stacked on top of one another. Take a look at how SSMS does it for an example (except SSMS does not have filtering and sorting)

Looks like you never set it up in 6.7 to allow multiple result sets to be viewed at the same time (like in SSMS)… It is practically useless in the current form.

I would much rather see it with two distinct result sets on the bottom... If you were returning a lot of sets (more than 5) you could ask if the user wanted them all in one grid. something like this image, but with the ability to be individually sorted filtered and grouped.

Hi,

Thank you for you suggestion.

TSS-1337 is created. We will discuss about this.

Kelly

Hi Kelly,

feature like suggest ljr,brithomas, etc, is more useful that your actual implementation.

It’s only my opinion.

Best regards,

Sergio

Thank you very much, Sergio. We will also take consider your suggestion.

Kelly

OK. Many thank’s for your answer,

Best regards,

Sergio

in the latest beta, the view to show all results is still not as useful as SSMS. The all results stacks the results on top of each other and there is no independent scroll bar for each result like in SSMS. The current implementation is not useful at all and the functionality of SSMS is superior in this respect. For the use case of doing multiple queries simultaneously, one doesn’t want the results to be shown in different tabs. Often one needs to look at the results all at the same time since the information is spread accross different queries. Please make it like SSMS for the independent scrolling windows embedded within the result set for each query result. This is the only thing that I don’t like about TOAD for SQL Server.