Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

Constant expressions may not appear in GROUP BY clause

You used a constant in the GROUP BY clause. Constants must not appear in the GROUP BY clause for a query. References to columns in a view that are constant are permitted in a GROUP BY clause. Also, expressions that use a view column that is constant are permitted.