In this blog post, you’ll learn more about the SQL Server Error Code 8710 and the error message description that is shown
SQL Server Error Code
8710
SQL Server Error Description for the Code :8710
Aggregate functions that are used with CUBE, ROLLUP, or GROUPING SET queries must provide for the merging of subaggregates. To fix this problem, remove the aggregate function or write the query using UNION ALL over GROUP BY clauses.