AND imp.grpcode LIKE @groupe
GROUP BY el3
--- PRE-ENGAGEMENT --
-INSERT INTO #cumuls
-SELECT
- el3,
- 'PRENGAGEMENT' typecumul,
- SUM(full_value) mont
-FROM oas_balance, oas_grplist imp
-WHERE
- oas_balance.cmpcode = 'AUF'
- AND imp.cmpcode = 'AUF'
- AND curcode = 'EUR'
- AND repbasis = 5
- AND balcode = 'PRENGAGEMENT'
- AND el1 NOT LIKE '4%'
- AND el1 NOT LIKE '96%'
- AND el1 NOT LIKE '97%'
- AND el1 NOT LIKE '98%'
- AND el3 LIKE @like_el3
- AND el3 = imp.code
- AND imp.elmlevel = 3
- AND imp.grpcode LIKE @groupe
-GROUP BY el3
+IF @exercice = YEAR(GETDATE())
+BEGIN
+ -- PRE-ENGAGEMENT --
+ INSERT INTO #cumuls
+ SELECT
+ el3,
+ 'PRENGAGEMENT' typecumul,
+ SUM(full_value) mont
+ FROM oas_balance, oas_grplist imp
+ WHERE
+ oas_balance.cmpcode = 'AUF'
+ AND imp.cmpcode = 'AUF'
+ AND curcode = 'EUR'
+ AND repbasis = 5
+ AND balcode = 'PRENGAGEMENT'
+ AND el1 NOT LIKE '4%'
+ AND el1 NOT LIKE '96%'
+ AND el1 NOT LIKE '97%'
+ AND el1 NOT LIKE '98%'
+ AND el3 LIKE @like_el3
+ AND el3 = imp.code
+ AND imp.elmlevel = 3
+ AND imp.grpcode LIKE @groupe
+ GROUP BY el3
--- ENGAGEMENT --
-INSERT INTO #cumuls
-SELECT
- el3,
- 'ENGAGEMENT' typecumul,
- SUM(full_value) mont
-FROM oas_balance, oas_grplist imp
-WHERE
- oas_balance.cmpcode = 'AUF'
- AND imp.cmpcode = 'AUF'
- AND curcode = 'EUR'
- AND repbasis = 5
- AND balcode = 'ENGAGEMENT'
- AND el1 NOT LIKE '4%'
- AND el1 NOT LIKE '96%'
- AND el1 NOT LIKE '97%'
- AND el1 NOT LIKE '98%'
- AND el3 LIKE @like_el3
- AND el3 = imp.code
- AND imp.elmlevel = 3
- AND imp.grpcode LIKE @groupe
-GROUP BY el3
+ -- ENGAGEMENT --
+ INSERT INTO #cumuls
+ SELECT
+ el3,
+ 'ENGAGEMENT' typecumul,
+ SUM(full_value) mont
+ FROM oas_balance, oas_grplist imp
+ WHERE
+ oas_balance.cmpcode = 'AUF'
+ AND imp.cmpcode = 'AUF'
+ AND curcode = 'EUR'
+ AND repbasis = 5
+ AND balcode = 'ENGAGEMENT'
+ AND el1 NOT LIKE '4%'
+ AND el1 NOT LIKE '96%'
+ AND el1 NOT LIKE '97%'
+ AND el1 NOT LIKE '98%'
+ AND el3 LIKE @like_el3
+ AND el3 = imp.code
+ AND imp.elmlevel = 3
+ AND imp.grpcode LIKE @groupe
+ GROUP BY el3
+END
SELECT
cumul.el3 projetPoste,