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 40 41 42
| ALTER PROCEDURE [dbo].[SyntheseCAFournisseur]
-- Add the parameters for the stored procedure here
@CodeFou varchar(9),
@CodeRegr varchar(20),
@DateDeb datetime,
@DateFin datetime
AS
BEGIN
SET NOCOUNT ON
SELECT 'C' AS SOCIETE
, T_Table2 AS code_regroupement
, e_contrepartieaux
, t_commentaire
, e_etablissement
, e_journal
, et_libelle
, e_refinterne
, SUM(e_debit - e_credit) AS SOLDE
, e_periode
FROM C.dbo.ecriture AS E
LEFT JOIN C.dbo.tiers AS T
ON E.e_contrepartieaux = T.t_auxiliaire
LEFT JOIN C.dbo.etabliss AS ET
ON E.e_etablissement = ET.et_etablissement
WHERE
AND T.T_TABLE2 = @CodeRegr
AND E.e_journal IN ('AC','ACO', 'AI', 'AIO')
AND E.e_datecomptable BETWEEN @DateDeb AND @DateFin
AND (E.e_general LIKE '6%' OR E.e_general LIKE '2%')
---
AND E.e_contrepartieaux = CASE WHEN @CodeFou IS NOT NULL THEN @CodeFou ELSE @CodeRegr END
---
GROUP BY E.e_contrepartieaux
, T.T_Table2
, T.t_commentaire
, E.e_etablissement
, ET.et_libelle
, E.e_journal
, E.e_periode
, E.e_refinterne
END |
Partager