SELECT 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-01-01 00:30:00' AND '2022-12-31 23:30:00') 
UNION 
SELECT 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-01-01 00:30:00' AND '2022-12-31 23:30:00');



/*
1.	Entre plusieurs dates
2.	REPR_0001 pour distinguer le secteur
*/


/*		2022				*/
SELECT '01_JANV', 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-01-01 00:30:00' AND '2022-01-31 23:30:00') 
UNION 
SELECT '01_JANV', 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-01-01 00:30:00' AND '2022-01-31 23:30:00') 
UNION 
SELECT '02_FEV', 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-02-01 00:30:00' AND '2022-02-28 23:30:00') 
UNION 
SELECT '02_FEV', 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-02-01 00:30:00' AND '2022-02-28 23:30:00') 
UNION 
SELECT '03_MARS', 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-03-01 00:30:00' AND '2022-03-31 23:30:00') 
UNION 
SELECT '03_MARS', 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-03-01 00:30:00' AND '2022-03-31 23:30:00') 
UNION 
SELECT '04_AVR', 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-04-01 00:30:00' AND '2022-04-30 23:30:00') 
UNION 
SELECT '04_AVR', 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-04-01 00:30:00' AND '2022-04-30 23:30:00') 
UNION 
SELECT '05_MAI', 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-05-01 00:30:00' AND '2022-05-31 23:30:00') 
UNION 
SELECT '05_MAI', 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-05-01 00:30:00' AND '2022-05-31 23:30:00') 
UNION 
SELECT '06_JUIN', 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-06-01 00:30:00' AND '2022-06-30 23:30:00') 
UNION 
SELECT '06_JUIN', 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-06-01 00:30:00' AND '2022-06-30 23:30:00') 
UNION 
SELECT '07_JUIL', 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-07-01 00:30:00' AND '2022-07-31 23:30:00') 
UNION 
SELECT '07_JUIL', 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-07-01 00:30:00' AND '2022-07-31 23:30:00') 
UNION 
SELECT '08_AOUT', 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-08-01 00:30:00' AND '2022-08-31 23:30:00') 
UNION 
SELECT '08_AOUT', 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-08-01 00:30:00' AND '2022-08-31 23:30:00') 
UNION 
SELECT '09_SEPT', 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') 
UNION 
SELECT '09_SEPT', 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') 
UNION 
SELECT '10_OCT', 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') 
UNION 
SELECT '10_OCT', 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') 
UNION 
SELECT '11_NOV', 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') 
UNION 
SELECT '11_NOV', 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') 
UNION 
SELECT '12_DEC', 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') 
UNION 
SELECT '12_DEC', 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')