CHECK Constraint For Allowing X Duplicates In Column
I wasn't sure if this is something that can be done in a CHECK constraint or if this requires a Stored Procedure for validating during insert, but can a constraint be created to allow only X amount of duplicates in a column, where X > 1?
Something along the lines of:
CONSTRAINT limiter_chk CHECK (SELECT COUNT(Id) AS Ct FROM Mytable WHERE Id = Id AND Count < 50)
I'm aware the the above isn't valid, but just trying to show the type of constraint I'm describing.
Business logic should be in the application, not the database.
However, you probably could write a TRIGGER to do what you are asking for.