In this blog post, let’s learn about the error message “8668 – Cannot create the clustered index ‘%.*ls’ on view ‘%.*ls’ because the select list of the view contains an expression on result of aggregate function or grouping column. Consider removing expression on result of aggregate function or grouping column from select list.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.
SQL Server Error Message
8668 – Cannot create the clustered index ‘%.*ls’ on view ‘%.*ls’ because the select list of the view contains an expression on result of aggregate function or grouping column. Consider removing expression on result of aggregate function or grouping column from select list.
Reason for the Error
To be update soon…
Solution
To be update soon…