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 '2021-01-01 00:30:00' AND '2021-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 '2021-01-01 00:30:00' AND '2021-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 '2021-02-01 00:30:00' AND '2021-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 '2021-02-01 00:30:00' AND '2021-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 '2021-03-01 00:30:00' AND '2021-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 '2021-03-01 00:30:00' AND '2021-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 '2021-04-01 00:30:00' AND '2021-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 '2021-04-01 00:30:00' AND '2021-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 '2021-05-01 00:30:00' AND '2021-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 '2021-05-01 00:30:00' AND '2021-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 '2021-06-01 00:30:00' AND '2021-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 '2021-06-01 00:30:00' AND '2021-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 '2021-07-01 00:30:00' AND '2021-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 '2021-07-01 00:30:00' AND '2021-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 '2021-08-01 00:30:00' AND '2021-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 '2021-08-01 00:30:00' AND '2021-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 '2021-09-01 00:30:00' AND '2021-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 '2021-09-01 00:30:00' AND '2021-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 '2021-10-01 00:30:00' AND '2021-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 '2021-10-01 00:30:00' AND '2021-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 '2021-11-01 00:30:00' AND '2021-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 '2021-11-01 00:30:00' AND '2021-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 '2021-12-01 00:30:00' AND '2021-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 '2021-12-01 00:30:00' AND '2021-12-31 23:30:00')