Infer Group By

I've often wanted the ability to select an inferred Group By. Imagine you have a query:

	Code:
	Select Field1, Count(*) From dbo.Table1

If I type in Group by, it would be awesome if it allowed me to click enter and put in Field1. Or more complex:

	Code:
	Select Field1, Field2, Field3, OtherValue = Left(Field4, 5), Count(*) From dbo.Table1

If I type in Group by, it would be awesome if it allowed me to click enter and put in "Field1, Field2, Field3, Left(Field4, 5)". You'd have to work out the Field = vs the As, but it is doable. Basically it is grabbing the select, ignoring the aggregates and column name aliases.

It's fairly easy to do for a single column using a code snippet

Create a new code snippet grpby
In the code of the snipped put something like

	Code:
	SELECT $OBJECT(ins_column)$, count(*) FROM $OBJECT()$ GROUP BY $OBJECT(ins_column)$ ORDER BY 1

Cool, but its never just one field.

Good idea!

+1

I have entered an enhancement request to enable selection of multiple columns using $OBJECT(ins_column)$ macro