...
The text of the spCheckForCustomerMatch stored procedure appears below but you can also find it in the Database Objects service if you installed the sample application.
...
spCheckForCustomerMatch
(@SourceID INT,
@FirstName NVARCHAR(255), |
...
...
...
@PhoneAreaCode NVARCHAR(20)) |
...
...
SELECT MatchType, ID FROM |
...
...
...
CASE
WHEN
(FirstName = @FirstName AND
LastName = @LastName AND
Phone = @Phone AND
PhoneAreaCode = @PhoneAreaCode AND
ID <> @SourceID)
THEN
1
WHEN
(FirstName = @FirstName AND
LastName = @LastName AND
ID <> @SourceID)
THEN
2
END,
ID FROM APTIFY..vwCustomers) CustomerMatch
WHERE MatchType IS NOT NULL
OLD -- CREATE PROC spCheckForCustomerMatch
(@SourceID INT,
@FirstName NVARCHAR(255),
@LastName NVARCHAR(255))
AS
SELECT MatchType, ID FROM
(SELECT MatchType
= CASE
WHEN
(FirstName = @FirstName AND
LastName = @LastName AND
ID <> @SourceID)
THEN
2
END,
ID FROM APTIFY..vwCustomers) CustomerMatch
WHERE MatchType IS NOT NULL |
Related topics
Filter by label (Content by label) |
---|
showLabels | false |
---|
sort | title |
---|
showSpace | false |
---|
labels | duplicate-records |
---|
|