Feature request: Remove "AS" clauses from Group By lines...
I use many "as" clauses in my selects. If I need to use a Group By clause, I can copy my Select items, but then I have to manually remove all of the "AS" clauses. It would be a dream to have them removed during a format!
Also, what would be involved in having a "change to other favorite connection" mechanism, so I can switch my current query between production, development and test? And it would be doubly sweet if the switch also changed to my usual db on that instance. Like an Alt-Tab allows you to switch between open windows.
Bill Ross
shared this idea
Thank you for your suggestion.
Ideally, we’d love to respond individually to every request, but currently we can’t due to the volume of unanswered tickets. We’re clearing up our UserVoice backlog to make it easier for us as a small team to prioritize the most valuable features moving forward. Therefore, due to a lack of recent interest in this ticket, we have decided to close it.
If you feel strongly about it, we encourage you to create a new request.
Thanks,
The Prompt Team
-
Jermy
commented
Also for ORDER BY, see also, my suggestion:
GROUP/ORDER BY Suggestions (http://redgate.uservoice.com/forums/94413-sql-prompt-feature-suggestions/suggestions/1605189-group-order-by-suggestions?tracking_code=f80026144c105f8eec65bfa821d9c9f8)