Please can the SQL code below be interpreted
IF @xMatchCriteria='MATCH12'
BEGIN
IF EXISTS (Select * from #InsightData where (EmailAddress=@xDCPEmailAddress ) )
BEGIN
SET @xTestMatchCriteria = @xMatchCriteria;
SELECT @xCRMCustomerId=CustomerId, @xCRMDcpCustomerId=DcpCustomerId, @xCRMPortalCustomerID=PortalCustomerID,@xCRMDcpID=DcpID, @xCRMCardNumber=CardNumber, @xCRMEmailAddress=EmailAddress, @xCRMfirtLetterFirstName=firtLetterFirstName,
@xCRMLastName=Surname,@xCRMAddressLine1=AddressLine1, @xCRMPostCode=PostCode
FROM #InsightData
where (EmailAddress=@xDCPEmailAddress )
END
ELSE
BEGIN
SET @xTestMatchCriteria='No'+@xMatchCriteria;
END
END
No Answer is Posted For this Question
Be the First to Post Answer
What is row level locking?
What is auto increment in mysql?
Explain MySQL optimization?
How can you change the name of any existing table by using the sql statement?
How to validate email addresses in mysql?
How many rows can mysql hold?
What is difference between inner vs self vs cross?
How many sql ddl commands are supported by 'mysql'?
How do I free up space in mysql?
Is mysql case-sensitive?
Is blocked because of many connection errors mysql?
Where the database is stored in mysql?