Search Results in Grid Mode
Find all occurrences of your search string in the results in datagrid mode. I know I should and could do this in SQL but sometime it is handle to find the customers name in a large set of rows.
![](https://secure.gravatar.com/avatar/8d701bcb113d966e44a392a902595188?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
-
Greg commented
SSMSBoost has all sorts of features that operate on the result grid - find, aggregate (sum/avg/min/max/etc) which was really useful. I'd love to see this built into SQL Prompt. Jason is right, I could rewrite the query to return the values I'm looking for, but when I'm debugging sometimes it's helpful to find a particular record in a dataset. An example from today - I had a query that was returning correctly when I added a where clause to a table, but when I took it off (as the code would run in production) it returned (correctly) ~1,000 rows. I needed to find my sample data in that dataset.