afficher les valeurs null d'un COUNT Résolu/Fermé

Question

Bonjour, 

voici ma requete :

select FinCommande.DO_Client, FinCommande.DO_NomCli, COUNT (FinCommande.DO_Piece) as nbcdes
from FinCommande 
where FinCommande.do_date between '01/01/2012' and '29/01/2014'
and (FinCommande.DO_Piece IN (SELECT DO_Piece FROM ACIBOIS.dbo.F_DOCLIGNE)
or FinCommande.DO_Piece IN (SELECT DL_PieceBC FROM ACIBOIS.dbo.F_DOCLIGNE))
group by FinCommande.do_client, FinCommande.DO_NomCli
order by FinCommande.DO_NomCli.

je souhaite afficher les resultat du COUNT (FinCommande.DO_Piece) as nbcdes

MEME SI LA VALEUR EST NULL

MERCI



Configuration: Windows 7 / Firefox 26.0

juliusescalibus · Answer

voici le moyen de le faire:

select d.DO_NomCli,d.nbdevis,c.nbcdes,cast(round((cast(c.nbcdes  as decimal(10,2))/cast(d.nbdevis  as decimal(10,2))) * 100, 2)as decimal(10,2)) as TxTrsf from ( SELECT  FinDevis.DO_NomCli, COUNT (DISTINCT FinDevis.do_piece) as nbdevis FROM FinDevis WHERE findevis.DO_Date BETWEEN '01/01/2012' AND '29/01/2014'
GROUP BY  FinDevis.DO_NomCli ) as D
left outer join (
select  FinCommande.DO_NomCli, COUNT (FinCommande.DO_Piece) as nbcdes from FinCommande where FinCommande.do_date between '01/01/2012' and '29/01/2014'
and (FinCommande.DO_Piece IN (SELECT DO_Piece FROM ACIBOIS.dbo.F_DOCLIGNE) or FinCommande.DO_Piece IN (SELECT DL_PieceBC FROM ACIBOIS.dbo.F_DOCLIGNE)) group by  FinCommande.DO_NomCli ) as C ON D.DO_NomCli=C.DO_NomCli 
order by d.DO_NomCli

Afficher les valeurs null d'un COUNT

1 réponse

Discussions similaires