Ólögleg netföng viðskiptavina skráð í DAX 2012

Created by: Gunnar Steinn Magnússon

Modified on: Thu, 23 Jan, 2020 at 9:13 PM

Þetta sækir öll netföng viðskiptavina sem eru ekki skráð með lögleg netföng (vantar @)

SELECT

VENDTABLE.ACCOUNTNUM AS CUSTID,

DIRPARTYTABLE.NAME AS CUSTNAME,

CASE LOGISTICSELECTRONICADDRESS.TYPE WHEN 1 THEN 'Phone' WHEN 2 THEN 'Email' END AS CONTACTTYPE,

LOGISTICSELECTRONICADDRESS.DESCRIPTION AS CONTACTNAME,

LOGISTICSELECTRONICADDRESS.LOCATOR AS CONTACTDETAILS

FROM DIRPARTYTABLE AS DIRPARTYTABLE

INNER JOIN VENDTABLE ON DIRPARTYTABLE.RECID = VENDTABLE.PARTY

INNER JOIN DIRPARTYLOCATION ON DIRPARTYTABLE.RECID = DIRPARTYLOCATION.PARTY

INNER JOIN LOGISTICSELECTRONICADDRESS ON DIRPARTYLOCATION.LOCATION = LOGISTICSELECTRONICADDRESS.LOCATION

WHERE LOGISTICSELECTRONICADDRESS.TYPE = 2 and isnull(LOGISTICSELECTRONICADDRESS.LOCATOR,'') not like '%@%'

Gunnar is the author of this solution article.

Did you find it helpful? Yes No