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 |
Partager