1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
| SELECT m.HDebModel, m.HFinModel,
mt.HDebut, mt.Hfin,
mt.Hdebut - HDebModel AS Retard_Debut,
mt.Hfin - HFinModel AS Retard_Fin,
m.HFinModel - m.HDebModel AS Nb_Heures_Prevues,
mt.Hfin - mt.Hdebut AS Nb_Heures_Effectuees,
mt.Hfin - mt.Hdebut - m.HFinModel + m.HDebModel AS Heures_supplementaires
FROM Mouvement mt
INNER JOIN AffectationUserSectHor a
ON mt.Matricule = a.Matricule
AND mt.Date BETWEEN a.DateDefAff AND a.DateFinAff
INNER JOIN ModeleHoraire m
ON a.CodeModHor = m.CodeModHor
WHERE m.Matricule = 1001
AND m.Date = '2015-01-14' |
Partager