SqlServer.Rules has false positive: SRD0200
ErikEJ opened this issue · 1 comments
ErikEJ commented
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)
ErikEJ commented
It was a nonsense join, not a false positive