1 2 3 4 5 6 7 8 9
| SELECT Mouvements.num_soc + ' ' + CAST(Mouvements.num_contrat AS varchar) AS contrat, Mouvements.pdv,
CAST(ROUND(SUM(Mouvements.prorata), 2) AS decimal(10, 2)) AS prorata, LEFT(Mouvements.echeance, 2)
+ '/' + RIGHT(Mouvements.echeance, 2) + '/' + CAST(YEAR(GETDATE()) AS char(4)) AS echeance, Mouvements.AgenceNom,
Mouvements.AgenceAdresse, Mouvements.AgenceVille
FROM Mouvements INNER JOIN
CotisVeh ON Mouvements.num_soc + ' ' + CAST(Mouvements.num_contrat AS varchar) = CotisVeh.Contrat
GROUP BY Mouvements.num_soc + ' ' + CAST(Mouvements.num_contrat AS varchar), Mouvements.pdv, LEFT(Mouvements.echeance, 2)
+ '/' + RIGHT(Mouvements.echeance, 2) + '/' + CAST(YEAR(GETDATE()) AS char(4)), Mouvements.AgenceNom,
Mouvements.AgenceAdresse, Mouvements.AgenceVille |
Partager