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

0 Answers  

---

What are features of mysql?

0 Answers  

---

Which is better sqlite or mysql?

0 Answers  

---

What is difference between mongodb and mysql?

0 Answers  

---

What are the 'mysql' command line options?

0 Answers  

---

What is data directory in mysql?

0 Answers  

---

How to create a test table in your mysql server?

0 Answers  

---

How to use count function in mysql?

0 Answers  

---

Where is mysql data stored?

0 Answers  

---

How to show table structure mysql?

0 Answers  

---

Which mysql function is used to concatenate string?

1 Answers  

---

What is the difference between GROUP BY and ORDER BY in Sql?

12 Answers   Creative, Renault Nissan, Trikon Networks,

---