Setting Business Constraint for Unique Combination of Multiple Columns in Master Data Services
Problem Statement
In Master Data Services, a business rule is a rule that you use to ensure the quality and accuracy of your master data.
Is it possible to have a business rule to ensure the uniqueness of value for a combination of columns (Composite key).
Solution
Output
Functions in SQL Server: Practical Guide