1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
|
WITH resultat (FK_ARTICLE, DEBTF, FINTF ,FIN_PR)
AS
(
SELECT e.FK_ARTICLE,e.DEBTF,e.FINTF,e.FIN_PR
FROM
(SELECT FK_ARTICLE, DEBTF, FINTF ,debtf AS DEB_PR,
dbo.min_date (DEBTF, FINTF, DEBRD, FINRD, DEBRP, FINRP, DEBTX, FINTX) as FIN_PR
FROM tarif_test.dbo.tab) AS e
UNION ALL
SELECT e.FK_ARTICLE,e.DEBTF,e.FINTF,e.FIN_PR
FROM
(SELECT FK_ARTICLE, DEBTF, FINTF ,debtf AS DEB_PR,
dbo.min_date (DEBTF, FINTF, DEBRD, FINRD, DEBRP, FINRP, DEBTX, FINTX) as FIN_PR
FROM tarif_test.dbo.tab) AS e
INNER JOIN resultat AS d
ON e.FIN_PR = d.debtf
)
SELECT FK_ARTICLE, DEBTF, FINTF,FIN_PR
FROM resultat |
Partager