You may not use ALL with CUBE or ROLLUP.

Message Text

You may not use ALL with CUBE or ROLLUP.

Explanation

There is an error in the syntax of your query. SQL Server Enterprise Manager has attempted to locate the source of the error.

Action

Review your query syntax and correct the error before running your query.

See Also
Summarizing Data Query Fundamentals
GROUP BY and ALL Using the Select List

 

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.