créer Requête récursive

Bonjour,
Je veux à chaque fois utiliser le résultat retourné par ma requête,et retourner enfin tous les résultats.Imbriqué plusieurs requêtes puis unir chaque partie c'est trop long et lent.
Ma requête est comme suit:
Code:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 sql SELECT code,DEBTF, FINTF ,DEBRD,FINRD,DEBRP, FINRP,DEBTX, FINTX ,DEBTF as deb_PR,Dateadd(day,Min(aa.NbJours),DEBTF) AS fin_PR from (SELECT *, DateDiff(day,CONVERT(DateTime,DEBTF,120),CONVERT(DateTime,DateTest ,120)) AS NbJours FROM ( SELECT code, DEBTF, FINTF, DEBRD AS DateTest FROM MaTable UNION SELECT code, DEBTF, FINTF, FINRD AS DateTest FROM MaTable UNION SELECT code, DEBTF, FINTF, DEBRP AS DateTest FROM MaTable UNION SELECT code, DEBTF, FINTF, FINRP AS DateTest FROM MaTable UNION SELECT code, DEBTF, FINTF, DEBTX AS DateTest FROM MaTable UNION SELECT code, DEBTF, FINTF, FINTX AS DateTest FROM MaTable ) AS SousRequete WHERE DateTest < FINTF ) aa where aa.NbJours > 0 group by code ,DEBTF, FINTF,DEBRD,FINRD,DEBRP, FINRP,DEBTX, FINTX
Je veux appliquer la même procédure sur la nouvelle colonne calculée (ici fin_ PR) et retourner tt les colonnes.
J'ai pensé aux requêtes récursives mais je peux pas inclure dedans des agrégations ni des unions.Donc ça pas marché.

Des suggestions?
Merci de m'aider.

SELECT code, DEBTF, FINTF, DEBRD, FINRD, DEBRP, FINRP, DEBTX, FINTX, DEBTF AS deb_PR,Dateadd(day,Min(aa.NbJours),DEBTF) AS fin_PR FROM (SELECT *, DateDiff(day,CONVERT(DateTime,DEBTF,120),CONVERT(DateTime,DateTest ,120)) AS NbJours FROM (SELECT code, DEBTF, FINTF, DEBRD AS DateTest FROM MaTable UNION SELECT code, DEBTF, FINTF, FINRD AS DateTest FROM MaTable UNION SELECT code, DEBTF, FINTF, DEBRP AS DateTest FROM MaTable UNION SELECT code, DEBTF, FINTF, FINRP AS DateTest FROM MaTable UNION SELECT code, DEBTF, FINTF, DEBTX AS DateTest FROM MaTable UNION SELECT code, DEBTF, FINTF, FINTX AS DateTest FROM MaTable) AS SousRequete WHERE DateTest < FINTF) aa WHERE aa.NbJours > 0 GROUP BY code, DEBTF, FINTF, DEBRD, FINRD, DEBRP, FINRP, DEBTX, FINTX