sqlwatch icon indicating copy to clipboard operation
sqlwatch copied to clipboard

SqlWatch 5.0 : stored procedure usp_sqlwatch_internal_expand_checks - BUG/Error

Open sozezzo opened this issue 3 years ago • 0 comments

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?.

sozezzo avatar Jan 31 '22 16:01 sozezzo