search

marcingminski / sqlwatch

SQL Server Performance Monitor
https://docs.sqlwatch.io
Other
436 stars 173 forks source link

SqlWatch 5.0 : stored procedure usp_sqlwatch_internal_expand_checks - BUG/Error #435

Open sozezzo opened 2 years ago

sozezzo commented 2 years ago

Describe the bug The stored procedure "usp_sqlwatch_internal_expand_checks" have an error:

Msg 1011, Level 16, State 1, Procedure usp_sqlwatch_internal_expand_checks, Line 282 [Batch Start Line 0] The correlation name 'cc' is specified multiple times in a FROM clause.

https://github.com/marcingminski/sqlwatch/blob/5.0/SqlWatch.Monitor/Project.SqlWatch.Database/dbo/Procedures/usp_sqlwatch_internal_expand_checks.sql

image

image

I think one table should be called 'cc' and the other 'c', but which one?.