You may not use ALL with CUBE or ROLLUP.
There is an error in the syntax of your query. SQL Server Enterprise Manager has attempted to locate the source of the error.
Review your query syntax and correct the error before running your query.
Summarizing Data | Query Fundamentals |
GROUP BY and ALL | Using the Select List |