1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
|
UPDATE @ReturnTable
SET Bon = Qte
FROM (SELECT TEMP.Nom AS [RESULT_Nom], COUNT(DISTINCT TEMP.Numero) AS [Qte], TEMP.FluxID AS [RESULT_FluxID], P.NumeroBadge
FROM @table_temporaire AS TEMP
INNER JOIN PASSAGES P WITH (nolock) ON P.Numero = TEMP.Numero AND P.NumeroBadge = TEMP.NumeroBadge AND P.ResultatControle = 1 AND DateHeure > @todayDate
GROUP BY TEMP.Nom, TEMP.FluxID, P.NumeroBadge) AS [RESULT]
WHERE Operateur = RESULT_Nom AND FluxID = RESULT_FluxID
/********************************************************/
UPDATE @ReturnTable
SET Retours = Qte
FROM (SELECT TEMP.Nom AS [RESULT_Nom], COUNT(DISTINCT TEMP.Numero) AS [Qte], TEMP.FluxID AS [RESULT_FluxID], P.NumeroBadge
FROM @table_temporaire AS TEMP
INNER JOIN PASSAGES P WITH (nolock) ON P.Numero = TEMP.Numero AND P.NumeroBadge = TEMP.NumeroBadge AND P.ResultatControle = 0 AND DateHeure > @todayDate
GROUP BY TEMP.Nom, TEMP.FluxID, P.NumeroBadge) AS [RESULT]
WHERE Operateur = RESULT_Nom AND FluxID = RESULT_FluxID |
Partager