In this blog post, let’s learn about the error message “8662 – Cannot create the clustered index “%.*ls” on view “%.*ls” because the view references an unknown value (SUM aggregate of nullable expression). Consider referencing only non-nullable values in SUM. ISNULL() may be useful for this.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.
SQL Server Error Message
8662 – Cannot create the clustered index “%.*ls” on view “%.*ls” because the view references an unknown value (SUM aggregate of nullable expression). Consider referencing only non-nullable values in SUM. ISNULL() may be useful for this.
Reason for the Error
To be update soon…
Solution
To be update soon…