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
about join
What is the current version of mysql?
How to show certain selected rows with the value "pcds".
What are the 3 main types of search queries?
What is the latest version of mysql?
Is mysql a backend?
What is a deterministic function?
What is mysql sleep process?
Explain the difference between delete and truncate.
What is delimiter in mysql stored procedure?
What does mysql_fetch_assoc do?
What is full form of xampp?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)