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 26 27 28 29 30 31 32 33 34 35
| Select
(T0.docnum) ,
(T0.Itemcode),
(T1.ItemName),
(T0.Duedate),
(T0.U_Datefinof),
(T0.U_Machine),
(T0.U_personnel),
sum (ISNULL (T0.U_NbreHeureOF, 0 )) AS [Nombre d'heure prévue] ,
sum (ISNULL (T0.U_NbreHeurereelle, 0 )) AS [Nombre d'heure Réel],
(T0.U_NbreHeurereelle - T0.U_NbreHeureOF)AS [Ecart] ,
T2.Name,
T0.U_Reglage,
T0.U_tpsreg ,
(T0.U_Reglage - T0.U_tpsreg ) AS [Ecart]
from OWOR T0
inner join OITM T1 on T0.itemcode = T1.Itemcode
full join [@REGLEUR] T2 on T0.U_regleur = T2. Code
full join [@PERSOCCT] T3 on T0.U_personnel = T3.Code
where T0.Status = 'L'
group by
T0.docnum ,
T0.Itemcode ,
T1.ItemName,
T0.Duedate,
T0.U_Datefinof,
T0.U_Machine,
T0.U_personnel ,
T0.U_NbreHeurereelle,
T0.U_NbreHeureOF,
(T2.Name),
T0.U_Reglage,
T0.U_tpsreg |
Partager