Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 1643 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Tell us something about heap tables?
Does mysql use t sql?
How do I download a mysql community server?
How do I get a list of table names in mysql?
What is DCL in MySQL?
What are procedures in mysql?
how to find 2nd highest salary in random database salary of employer.....
what is a cursor? : Mysql dba
How to create a new table by selecting rows from another table in mysql?
Is mysql good for big data?
What is mysql enterprise edition?
What is mysql optimization?
-
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)
