rr-wfm/MSBuild.Sdk.SqlProj

SqlServer.Rules has false positive: SRD0200

ErikEJ opened this issue · 1 comments

https://github.com/tcartwright/SqlServer.Rules/blob/master/docs/Design/SRD0020.md

        SELECT COUNT(*)
        FROM [dbo].[MTG] AS [mtg]
        INNER JOIN [dbo].[MTG] AS [mtgr] on [mtg].[RegionId] = [mtgr].[RegionId]
        WHERE [mtg].[GroupId] = @groupId 

(Self joined table, and RegionId is a FK)

It was a nonsense join, not a false positive