1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
| WITH
CTE_SLASH AS
(
SELECT SUBSTRING(description, 0,CHARINDEX('/',description)) AS groupe_juridique
FROM e_infos_relances RELANCES
JOIN e_factures_nonreglees IMPAYES ON RELANCES.dossier = IMPAYES.dossier
WHERE SUBSTRING(description, 0,CHARINDEX('/',description)) IS NOT NULL
AND SUBSTRING(description, 0,CHARINDEX('/',description)) <> ''
AND periode >= '22/05/2008'
AND periode <= '23/05/2008'
),
CTE_TIRET AS
(
SELECT SUBSTRING(description, 0,CHARINDEX('-',description)) AS groupe_juridique
FROM e_infos_relances RELANCES
JOIN e_factures_nonreglees IMPAYES ON RELANCES.dossier = IMPAYES.dossier
WHERE SUBSTRING(description, 0,CHARINDEX('-',description)) IS NOT NULL
AND SUBSTRING(description, 0,CHARINDEX('-',description)) <> ''
AND periode >= '22/05/2008'
AND periode <= '23/05/2008'
)
SELECT groupe_juridique FROM CTE_SLASH
UNION
SELECT groupe_juridique FROM CTE_TIRET |
Partager