SELECT '22_09_SEPT 2022', CARTOFLEX_CONTACTS_PROSPECT_V.NOMTIERS, CARTOFLEX_CONTACTS_PROSPECT_V.TIERS, CARTOFLEX_CONTACTS_PROSPECT_V.VIL, CARTOFLEX_CONTACTS_PROSPECT_V.USERCRDH, CARTOFLEX_CONTACTS_PROSPECT_V.ORIGCOD, CARTOFLEX_CONTACTS_PROSPECT_V.REPR_0001 
FROM CARTOFLEX.dbo.CARTOFLEX_CONTACTS_PROSPECT_V CARTOFLEX_CONTACTS_PROSPECT_V
WHERE (CARTOFLEX_CONTACTS_PROSPECT_V.USERCRDH BETWEEN '2022-09-01 00:30:00' AND '2022-09-30 23:30:00') AND CARTOFLEX_CONTACTS_PROSPECT_V.ORIGCOD = 'WEB' AND CARTOFLEX_CONTACTS_PROSPECT_V.REPR_0001 IN ('SP', 'OC', 'ED')
UNION 
SELECT '22_09_SEPT 2022', CARTOFLEX_CONTACTS_CLIENT_V.NOMTIERS, CARTOFLEX_CONTACTS_CLIENT_V.TIERS, CARTOFLEX_CONTACTS_CLIENT_V.VIL, CARTOFLEX_CONTACTS_CLIENT_V.USERCRDH, CARTOFLEX_CONTACTS_CLIENT_V.ORIGCOD, CARTOFLEX_CONTACTS_CLIENT_V.REPR_0001 
FROM CARTOFLEX.dbo.CARTOFLEX_CONTACTS_CLIENT_V CARTOFLEX_CONTACTS_CLIENT_V
WHERE (CARTOFLEX_CONTACTS_CLIENT_V.USERCRDH BETWEEN '2022-09-01 00:30:00' AND '2022-09-30 23:30:00') AND CARTOFLEX_CONTACTS_CLIENT_V.ORIGCOD = 'WEB' AND CARTOFLEX_CONTACTS_CLIENT_V.REPR_0001 IN ('SP', 'OC', 'ED')
UNION 
SELECT '22_10_OCT 2022', CARTOFLEX_CONTACTS_PROSPECT_V.NOMTIERS, CARTOFLEX_CONTACTS_PROSPECT_V.TIERS, CARTOFLEX_CONTACTS_PROSPECT_V.VIL, CARTOFLEX_CONTACTS_PROSPECT_V.USERCRDH, CARTOFLEX_CONTACTS_PROSPECT_V.ORIGCOD, CARTOFLEX_CONTACTS_PROSPECT_V.REPR_0001 
FROM CARTOFLEX.dbo.CARTOFLEX_CONTACTS_PROSPECT_V CARTOFLEX_CONTACTS_PROSPECT_V
WHERE (CARTOFLEX_CONTACTS_PROSPECT_V.USERCRDH BETWEEN '2022-10-01 00:30:00' AND '2022-10-31 23:30:00') AND CARTOFLEX_CONTACTS_PROSPECT_V.ORIGCOD = 'WEB' AND CARTOFLEX_CONTACTS_PROSPECT_V.REPR_0001 IN ('SP', 'OC', 'ED')
UNION 
SELECT '22_10_OCT 2022', CARTOFLEX_CONTACTS_CLIENT_V.NOMTIERS, CARTOFLEX_CONTACTS_CLIENT_V.TIERS, CARTOFLEX_CONTACTS_CLIENT_V.VIL, CARTOFLEX_CONTACTS_CLIENT_V.USERCRDH, CARTOFLEX_CONTACTS_CLIENT_V.ORIGCOD, CARTOFLEX_CONTACTS_CLIENT_V.REPR_0001 
FROM CARTOFLEX.dbo.CARTOFLEX_CONTACTS_CLIENT_V CARTOFLEX_CONTACTS_CLIENT_V
WHERE (CARTOFLEX_CONTACTS_CLIENT_V.USERCRDH BETWEEN '2022-10-01 00:30:00' AND '2022-10-31 23:30:00') AND CARTOFLEX_CONTACTS_CLIENT_V.ORIGCOD = 'WEB' AND CARTOFLEX_CONTACTS_CLIENT_V.REPR_0001 IN ('SP', 'OC', 'ED')
UNION 
SELECT '22_11_NOV 2022', CARTOFLEX_CONTACTS_PROSPECT_V.NOMTIERS, CARTOFLEX_CONTACTS_PROSPECT_V.TIERS, CARTOFLEX_CONTACTS_PROSPECT_V.VIL, CARTOFLEX_CONTACTS_PROSPECT_V.USERCRDH, CARTOFLEX_CONTACTS_PROSPECT_V.ORIGCOD, CARTOFLEX_CONTACTS_PROSPECT_V.REPR_0001 
FROM CARTOFLEX.dbo.CARTOFLEX_CONTACTS_PROSPECT_V CARTOFLEX_CONTACTS_PROSPECT_V
WHERE (CARTOFLEX_CONTACTS_PROSPECT_V.USERCRDH BETWEEN '2022-11-01 00:30:00' AND '2022-11-30 23:30:00') AND CARTOFLEX_CONTACTS_PROSPECT_V.ORIGCOD = 'WEB' AND CARTOFLEX_CONTACTS_PROSPECT_V.REPR_0001 IN ('SP', 'OC', 'ED')
UNION 
SELECT '22_11_NOV 2022', CARTOFLEX_CONTACTS_CLIENT_V.NOMTIERS, CARTOFLEX_CONTACTS_CLIENT_V.TIERS, CARTOFLEX_CONTACTS_CLIENT_V.VIL, CARTOFLEX_CONTACTS_CLIENT_V.USERCRDH, CARTOFLEX_CONTACTS_CLIENT_V.ORIGCOD, CARTOFLEX_CONTACTS_CLIENT_V.REPR_0001 
FROM CARTOFLEX.dbo.CARTOFLEX_CONTACTS_CLIENT_V CARTOFLEX_CONTACTS_CLIENT_V
WHERE (CARTOFLEX_CONTACTS_CLIENT_V.USERCRDH BETWEEN '2022-11-01 00:30:00' AND '2022-11-30 23:30:00') AND CARTOFLEX_CONTACTS_CLIENT_V.ORIGCOD = 'WEB' AND CARTOFLEX_CONTACTS_CLIENT_V.REPR_0001 IN ('SP', 'OC', 'ED')
UNION 
SELECT '22_12_DEC 2022', CARTOFLEX_CONTACTS_PROSPECT_V.NOMTIERS, CARTOFLEX_CONTACTS_PROSPECT_V.TIERS, CARTOFLEX_CONTACTS_PROSPECT_V.VIL, CARTOFLEX_CONTACTS_PROSPECT_V.USERCRDH, CARTOFLEX_CONTACTS_PROSPECT_V.ORIGCOD, CARTOFLEX_CONTACTS_PROSPECT_V.REPR_0001 
FROM CARTOFLEX.dbo.CARTOFLEX_CONTACTS_PROSPECT_V CARTOFLEX_CONTACTS_PROSPECT_V
WHERE (CARTOFLEX_CONTACTS_PROSPECT_V.USERCRDH BETWEEN '2022-12-01 00:30:00' AND '2022-12-31 23:30:00') AND CARTOFLEX_CONTACTS_PROSPECT_V.ORIGCOD = 'WEB' AND CARTOFLEX_CONTACTS_PROSPECT_V.REPR_0001 IN ('SP', 'OC', 'ED')
UNION 
SELECT '22_12_DEC 2022', CARTOFLEX_CONTACTS_CLIENT_V.NOMTIERS, CARTOFLEX_CONTACTS_CLIENT_V.TIERS, CARTOFLEX_CONTACTS_CLIENT_V.VIL, CARTOFLEX_CONTACTS_CLIENT_V.USERCRDH, CARTOFLEX_CONTACTS_CLIENT_V.ORIGCOD, CARTOFLEX_CONTACTS_CLIENT_V.REPR_0001 
FROM CARTOFLEX.dbo.CARTOFLEX_CONTACTS_CLIENT_V CARTOFLEX_CONTACTS_CLIENT_V
WHERE (CARTOFLEX_CONTACTS_CLIENT_V.USERCRDH BETWEEN '2022-12-01 00:30:00' AND '2022-12-31 23:30:00') AND CARTOFLEX_CONTACTS_CLIENT_V.ORIGCOD = 'WEB' AND CARTOFLEX_CONTACTS_CLIENT_V.REPR_0001 IN ('SP', 'OC', 'ED')
UNION 
SELECT '23_01_JANV 2023', CARTOFLEX_CONTACTS_PROSPECT_V.NOMTIERS, CARTOFLEX_CONTACTS_PROSPECT_V.TIERS, CARTOFLEX_CONTACTS_PROSPECT_V.VIL, CARTOFLEX_CONTACTS_PROSPECT_V.USERCRDH, CARTOFLEX_CONTACTS_PROSPECT_V.ORIGCOD, CARTOFLEX_CONTACTS_PROSPECT_V.REPR_0001 
FROM CARTOFLEX.dbo.CARTOFLEX_CONTACTS_PROSPECT_V CARTOFLEX_CONTACTS_PROSPECT_V
WHERE (CARTOFLEX_CONTACTS_PROSPECT_V.USERCRDH BETWEEN '2023-01-01 00:30:00' AND '2023-01-31 23:30:00') AND CARTOFLEX_CONTACTS_PROSPECT_V.ORIGCOD = 'WEB' AND CARTOFLEX_CONTACTS_PROSPECT_V.REPR_0001 IN ('SP', 'OC', 'ED')
UNION 
SELECT '23_01_JANV 2023', CARTOFLEX_CONTACTS_CLIENT_V.NOMTIERS, CARTOFLEX_CONTACTS_CLIENT_V.TIERS, CARTOFLEX_CONTACTS_CLIENT_V.VIL, CARTOFLEX_CONTACTS_CLIENT_V.USERCRDH, CARTOFLEX_CONTACTS_CLIENT_V.ORIGCOD, CARTOFLEX_CONTACTS_CLIENT_V.REPR_0001 
FROM CARTOFLEX.dbo.CARTOFLEX_CONTACTS_CLIENT_V CARTOFLEX_CONTACTS_CLIENT_V
WHERE (CARTOFLEX_CONTACTS_CLIENT_V.USERCRDH BETWEEN '2023-01-01 00:30:00' AND '2023-01-31 23:30:00') AND CARTOFLEX_CONTACTS_CLIENT_V.ORIGCOD = 'WEB' AND CARTOFLEX_CONTACTS_CLIENT_V.REPR_0001 IN ('SP', 'OC', 'ED');



	?cecile.perrottet@cma-idf.fr


SELECT DISTINCT 
CLI.TIERS, 'CLIENT', CLI.EMAIL, CLI.EMAILCONTACT, CLI.RUE, CLI.LOC, CLI.CPOSTAL, CLI.VIL, CLI."RAISON SOCIAL CLIENT", CLI.NOM, CLI.TITRELIBELLE, CLI.PRENOM, CLI.NOMCOMTACT, CLI.FONCTION1, CLI.REPR_0001
FROM CARTOFLEX.dbo.CARTOFLEX_CONTACTS_CLIENT_V CLI 
WHERE CLI.DOS='1' 
AND (CLI.REPR_0001 = 'ACS') 
AND (CLI.TIERS = 'C0011757') 
UNION
SELECT DISTINCT 
PRO.TIERS, 'PROSPECT', PRO.EMAIL, PRO.EMAILCONTACT, PRO.RUE, PRO.LOC, PRO.CPOSTAL, PRO.VIL, PRO."RAISON SOCIAL PROSPECT", PRO.NOM, PRO.TITRELIBELLE, PRO.PRENOM, PRO.NOMCOMTACT, PRO.FONCTION1, PRO.REPR_0001 
FROM CARTOFLEX.dbo.CARTOFLEX_CONTACTS_PROSPECT_V PRO 
WHERE PRO.DOS='1' 
AND (PRO.REPR_0001 = 'ACS') 
AND (PRO.TIERS = 'C0011757') 



SELECT DISTINCT 
CLI.TIERS, 'CLIENT', CLI.EMAIL, CLI.EMAILCONTACT, CLI.RUE, CLI.LOC, CLI.CPOSTAL, CLI.VIL, CLI."RAISON SOCIAL CLIENT", CLI.NOM, CLI.TITRELIBELLE, CLI.PRENOM, CLI.NOMCOMTACT, CLI.FONCTION1, CLI.REPR_0001
FROM CARTOFLEX.dbo.CARTOFLEX_CONTACTS_CLIENT_V CLI 
WHERE CLI.DOS='1' 
AND (CLI.REPR_0001 = 'ACS') 
AND (CLI.TIERS = 'C0011757') 
AND (CLI.EMAILCONTACT = '?cecile.perrottet@cma-idf.fr') 

SELECT CLI.CLI_ID, CLI.TIERS, CLI.EMAIL, CLI.EMAILCONTACT, CLI.RUE, CLI.LOC, CLI.CPOSTAL, CLI.VIL, CLI."RAISON SOCIAL CLIENT", CLI.NOM, CLI.TITRELIBELLE, CLI.PRENOM, CLI.NOMCOMTACT, CLI.FONCTION1, CLI.REPR_0001 
FROM CARTOFLEX.dbo.CARTOFLEX_CONTACTS_CLIENT_V CLI 
WHERE CLI.DOS='1' 
AND (CLI.REPR_0001 = 'ACS') 
AND (CLI.TIERS = 'C0011757') 
AND (CLI.EMAILCONTACT = '?cecile.perrottet@cma-idf.fr') 
AND (CLI.T2_ID = 51417) 
AND (CLI.CLI_ID = 8856);


UPDATE CARTOFLEX.dbo.CARTOFLEX_CONTACTS_CLIENT_V CLI SET CLI.EMAILCONTACT = 'cecile.perrottet@cma-idf.fr' 
WHERE CLI.DOS='1' AND (CLI.REPR_0001 = 'ACS') AND (CLI.TIERS = 'C0011757') AND (CLI.EMAILCONTACT = '?cecile.perrottet@cma-idf.fr') AND (CLI.T2_ID = 51417) AND (CLI.CLI_ID = 8856);

SELECT CLI.CLI_ID, CLI.TIERS, CLI.EMAIL, CLI.EMAILCONTACT
FROM CARTOFLEX.dbo.CARTOFLEX_CONTACTS_CLIENT_V CLI
WHERE (CLI.DOS='1') AND (CLI.EMAILCONTACT Like '%!%' OR CLI.EMAILCONTACT Like '%?%' OR CLI.EMAILCONTACT Like '%é%' OR CLI.EMAILCONTACT Like '%è%' OR CLI.EMAILCONTACT Like '%à%')



SELECT PRO.PRO_ID, PRO.TIERS, 'PROSPECT', PRO.EMAIL, PRO.EMAILCONTACT, PRO.RUE, PRO.LOC, PRO.CPOSTAL, PRO.VIL, PRO."RAISON SOCIAL PROSPECT", PRO.NOM, PRO.TITRELIBELLE, PRO.PRENOM, PRO.NOMCOMTACT, PRO.FONCTION1, PRO.REPR_0001
FROM CARTOFLEX.dbo.CARTOFLEX_CONTACTS_PROSPECT_V PRO
WHERE (PRO.DOS='1') AND (PRO.NOMCOMTACT Like 'DEBR%')


UPDATE CARTOFLEX.dbo.CARTOFLEX_CONTACTS_PROSPECT_V PRO SET PRO.EMAILCONTACT = 'bertrand.debron@' WHERE PRO.PRO_ID = 38303;


SELECT PRO.EMAILCONTACT, 
FROM CARTOFLEX.dbo.CARTOFLEX_CONTACTS_PROSPECT_V PRO
WHERE PRO.PRO_ID = 38303;