GROUP BY Feature Request / Enhancement

aultmike

Hello,

I wanted to suggest an enhancement to your SQL Prompt product.. which I *LOVE* by the way!

If I type

SELECT City, State From Addresses

and I begin to type GROUP BY and press the space bar ... I think it would be awesome for the first suggestion in the intellisense to be City, State. Because If I explicitly type n number of columns I think it would be safe to assume that I want to aggregate on these columns.

I also believe that it would be cool if the ORDER BY operated the same way as the GROUP BY.

MikeyC

I second this suggestion. Though I would add that it might make sense to leave out aggregate fields from the SELECT clause. (Though it wouldn't be a big deal to delete them manually.) As it is now I usually select, copy, and paste the fields from the SELECT portion of the statement for the GROUP BY and ORDER BY.