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 36 37 38 39
| Use BIJOU1
SELECT P_DOSSIER.D_RaisonSoc As Societe, F_ECRITUREC.CT_Num AS TIERS, F_COMPTET.CT_Intitule AS [Intitulé Tiers],
SUM(case when (dbo.F_ECRITUREC.CG_Num = '41111000') Then (- (F_ECRITUREC.EC_Montant * F_ECRITUREC.EC_Sens + F_ECRITUREC.EC_Montant * F_ECRITUREC.EC_Sens - F_ECRITUREC.EC_Montant))
else 0 end) AS SOLDE411,
SUM(case when (dbo.F_ECRITUREC.CG_Num = '41300000') Then (- (F_ECRITUREC.EC_Montant * F_ECRITUREC.EC_Sens + F_ECRITUREC.EC_Montant * F_ECRITUREC.EC_Sens - F_ECRITUREC.EC_Montant))
else 0 end) AS SOLDE413,
F_COMPTET.CT_ASSURANCE AS [Assurance Crédit],F_COMPTET.CT_ENCOURS AS [Encours Maximum],
(F_COMPTET.CT_ASSURANCE - F_COMPTET.CT_ENCOURS) AS [Risque Réel],YEAR(F_ECRITUREC.EC_Date) AS Année
FROM P_DOSSIER, F_ECRITUREC INNER JOIN
F_COMPTET ON F_ECRITUREC.CT_Num = F_COMPTET.CT_Num
WHERE YEAR(F_ECRITUREC.EC_Date) = '2008' AND dbo.F_ECRITUREC.CG_Num IN('41111000', '41300000')
GROUP BY /*MONTH(F_ECRITUREC.EC_Date),*/P_DOSSIER.D_RaisonSoc, F_ECRITUREC.CT_Num, F_COMPTET.CT_ASSURANCE,F_COMPTET.CT_ENCOURS,YEAR(F_ECRITUREC.EC_Date),
F_COMPTET.CT_Intitule, F_COMPTET.CT_Type
HAVING (F_ECRITUREC.CT_Num IS NOT NULL) AND (F_COMPTET.CT_Type = 0)
ORDER BY F_ECRITUREC.CT_Num
UNION
Use BIJOU2
SELECT P_DOSSIER.D_RaisonSoc As Societe, F_ECRITUREC.CT_Num AS TIERS, F_COMPTET.CT_Intitule AS [Intitulé Tiers],
SUM(case when (dbo.F_ECRITUREC.CG_Num = '41111000') Then (- (F_ECRITUREC.EC_Montant * F_ECRITUREC.EC_Sens + F_ECRITUREC.EC_Montant * F_ECRITUREC.EC_Sens - F_ECRITUREC.EC_Montant))
else 0 end) AS SOLDE411,
SUM(case when (dbo.F_ECRITUREC.CG_Num = '41300000') Then (- (F_ECRITUREC.EC_Montant * F_ECRITUREC.EC_Sens + F_ECRITUREC.EC_Montant * F_ECRITUREC.EC_Sens - F_ECRITUREC.EC_Montant))
else 0 end) AS SOLDE413,
F_COMPTET.CT_ASSURANCE AS [Assurance Crédit],F_COMPTET.CT_ENCOURS AS [Encours Maximum],
(F_COMPTET.CT_ASSURANCE - F_COMPTET.CT_ENCOURS) AS [Risque Réel],YEAR(F_ECRITUREC.EC_Date) AS Année
FROM P_DOSSIER, F_ECRITUREC INNER JOIN
F_COMPTET ON F_ECRITUREC.CT_Num = F_COMPTET.CT_Num
WHERE YEAR(F_ECRITUREC.EC_Date) = '2008' AND dbo.F_ECRITUREC.CG_Num IN('41111000', '41300000')
GROUP BY /*MONTH(F_ECRITUREC.EC_Date),*/P_DOSSIER.D_RaisonSoc, F_ECRITUREC.CT_Num, F_COMPTET.CT_ASSURANCE,F_COMPTET.CT_ENCOURS,YEAR(F_ECRITUREC.EC_Date),
F_COMPTET.CT_Intitule, F_COMPTET.CT_Type
HAVING (F_ECRITUREC.CT_Num IS NOT NULL) AND (F_COMPTET.CT_Type = 0)
ORDER BY F_ECRITUREC.CT_Num |
Partager