SQL Server Error : 164 Details
SQL Server Error: 164 Severity: 15 Event Logged or not: No Description: Each GROUP BY expression must contain at least one column that is not an outer reference. Severity 15 Description: Indicates syntax errors in the Transact-SQL command.
Solution for Resolving the Error
SQL Server does not know positional arguments in group by part of the statement.
So, the column name needs repeatetion in group by part.
The positional syntax is only permitted for order by like 1,2 etc.
In general it is better to use column names in the order by clause as well to be clear.
Some … Read the rest