Larry Brister
asked on
SQL Server any 3 of 5 match
I have an Individuals table with FName, LName, Address1, EMailAddress, Phone in it... (Among other things)
I have an inbound record that I need to match against those items
So that if any 3 of the 5 match
I get a @dupe=1 message
I have an inbound record that I need to match against those items
So that if any 3 of the 5 match
I get a @dupe=1 message
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I guess user ask for a column that shows dup/no dup based on those condition...
not filter and get just those records...
not filter and get just those records...
ASKER