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
- 1156 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is the maximum number of columns per table?
Write a query to create a database and a table?
What is the purpose of -> in the mysql terminal?
What is int unsigned?
How does limit work in mysql?
What are mysql queries?
What is triggers?
Explain the difference between delete and truncate.
How do I switch users in mysql?
How would concatenate strings in mysql?
What is mysql connection limit?
in a master-master replication with two masters and alternate slaves running on two systems.can i have a script or any mysql command to know which one is right now acting as master.
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
