Add Excel Like Gripd To Results Options
Add to the Results To options an Excel Like grid that presents the results i8n a grid but allows for Excel like functuionality without re-executing the query.
I often am sending my data (via copy & paste) to Excel for aditional reserahc because the query takes a long time to run and I alrady have the core data I needd, I just need to fin tune it bu re-sorting or even re-aggregating the data differently.
It wulod be a killer plus if Microsoft simply reaplced the existing SSMS Grid with a mini-version of Excel but since Thats not likely any time soon how about provodong the Red=Gate Spreadhseet grid for SSMS?
BlueCollarCritic
shared this idea
-
John Barone
commented
Thanks!
-
Anonymous
commented
I used ApexSQL a while back and I think that had it (could aggregate, find, sort, filter, find).
https://knowledgebase.apexsql.com/perform-advanced-data-search-results-grid/
SSMSBoost has "Results Grid Aggregates"
-
John Barone
commented
Wow I didn't know SQL Prompt added that. Thanks for the tip!! I tried it yesterday, and it worked splendidly. It is way better than the "copy the results with headers and then paste into a blank worksheet" method I've been using.
-
Anonymous
commented
If you have the results in SSMS grid, why don't you just right click and choose SQL Prompt's featuer addition "Open In Excel"
The results grid will be written to an xlsx file and then it will be opened automatically? -
John Barone
commented
The product I am currently using is SoftTree SQL Assistant. I didn't include that in mu original comment because I wasn't sure if that would cause it to be flagged.
-
BlueCollarCritic
commented
@John Barone - Hopefully your monitoring this thread because I can't see a way to send you a msg. Would you share the name of this SQL toolkit you refer to? I'm assuming the name is not SQL Toolkit.
-
John Barone
commented
I actually pay for and use another product instead of using SQL Prompt (which I pay for too as part of SQL Toolkit) precisely because it offers a sortable results grid in SSMS and Visual Studio. It pains me to do this, because SQL Prompt is such an elegant product, but since I have to use the other product for the grid, then I just use it for everything else too.