1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
|
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 |
Partager