1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
| select datepart(ww,CURRENT_TIMESTAMP)Semaines,
datepart(yyyy,CURRENT_TIMESTAMP)Année,
COMC."CodeClient" "Code Client",
cli."NomClient" NOM,
Count(NoCommande) "Nb de ligne",
[color=blue][b]IF select sum(DateDiff(day,DatePromisePlusTard,getdate()))< 6
then sum(DateDiff(day,DatePromisePlusTard,getdate()))"Nb Jours r1"
else sum(DateDiff(day,DatePromisePlusTard,getdate())/7*5)"Nb Jours r1",[/b][/color]
sum( ResteLivrer*PrixUnitEnDevise) "C.A à Expedier"
FROM
GMT.dbo.COMC COMC INNER JOIN GMT.dbo.CLI CLI ON
COMC."CodeClient" = CLI."CodeClient"
WHERE
ResteExpedier='O' AND DateDiff(day,DatePromisePlusTard,getdate())>0
group by COMC."CodeClient",cli."NomClient" |
Partager