1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
|
SELECT *
FROM (
SELECT
[NUM_CDE_WEB]
,[NUM_FACTURE]
, ADRESSE_EMAIL AS RegistrationId
,substring([NUM_DAT_CDE],7,4) + substring([NUM_DAT_CDE],4,2) + substring([NUM_DAT_CDE],1,2) [NUM_DAT_CDE]
, [ID_CLIENT_SRD]
, [ID_CODESOURCE]
, [OFFRE]
, [MODE_PAIEMENT]
, [MODE_LIVRAISON]
,ROW_NUMBER()OVER (PARTITION BY NUM_CDE_WEB ORDER BY NUM_FACTURE) RNK
FROM [Experian.Qas.MatchData].dbo.[online_VAD] AS vad
JOIN [Experian.Qas.MatchUnify].[dbo].SearchResults_EMAIL_Golden AS email
WHERE [NUM_CDE_WEB] <>' ' AND [NUM_CDE_WEB] IS NOT NULL AND [MODE_PAIEMENT] <>' ' AND [MODE_PAIEMENT] IS NOT NULL
AND [MODE_LIVRAISON] <>' ' AND [MODE_LIVRAISON] IS NOT NULL AND [NUM_CDE_WEB] IN (SELECT DISTINCT [NUM_CDE_WEB] FROM [Experian.Qas.MatchData].dbo.[online_VAD] )
GROUP BY
[NUM_CDE_WEB]
, [NUM_FACTURE]
, ADRESSE_EMAIL
, [NUM_DAT_CDE]
, [ID_CLIENT_SRD]
, [ID_CODESOURCE]
, [OFFRE]
, [MODE_PAIEMENT]
, [MODE_LIVRAISON]T
WHERE T.RNK=1 |
Partager