Describe the bug
Looking at list of invoices for past year, I discovered that we have several duplicates and they should be unique ...
select * FROM dbo.Donations RIGHT OUTER JOIN dbo.Invoices ON dbo.Donations.Id = dbo.Invoices.DonationId where dbo.Invoices.Sequence in (722,1044,1079,1186,1354,1381,1576,1610,2359,2385,2525,2652,4066,4123,4601,5867,7330) and Year=2023
Describe the bug Looking at list of invoices for past year, I discovered that we have several duplicates and they should be unique ...
select * FROM dbo.Donations RIGHT OUTER JOIN dbo.Invoices ON dbo.Donations.Id = dbo.Invoices.DonationId where dbo.Invoices.Sequence in (722,1044,1079,1186,1354,1381,1576,1610,2359,2385,2525,2652,4066,4123,4601,5867,7330) and Year=2023