Error in GROUP BY clause near <Stringname>.

There is an error in the syntax of your query. The Query Designer has attempted to locate the source of the error. Review your query syntax and correct the error before running your query.

For more information, see Specifying Search Criteria (Visual Database Tools) and Aggregate Functions (Transact-SQL).

See Also

Concepts

Error Messages in Visual Database Tools

Other Resources

Grouping Rows with GROUP BY
GROUP BY and ALL
GROUP BY and Null Values
GROUP BY Components

Help and Information

Getting SQL Server 2005 Assistance