SUM(CASE WHEN dbo.F_ARTGAMME.EG_Enumere = 36 THEN dbo.F_GAMSTOCK.GS_QteSto ELSE 0 END) AS [36],
SELECT dbo.F_GAMSTOCK.AR_Ref , CASE WHEN dbo.F_ARTGAMME.EG_Enumere = 36 THEN SUM(dbo.F_GAMSTOCK.GS_QteSto) END AS [36], CASE WHEN dbo.F_ARTGAMME.EG_Enumere = 38 THEN SUM(dbo.F_GAMSTOCK.GS_QteSto) END AS [38], CASE WHEN dbo.F_ARTGAMME.EG_Enumere = 40 THEN SUM(dbo.F_GAMSTOCK.GS_QteSto) END AS [40] FROM dbo.F_GAMSTOCK INNER JOIN dbo.F_ARTICLE ON dbo.F_GAMSTOCK.AR_Ref = dbo.F_ARTICLE.AR_Ref INNER JOIN dbo.F_ARTGAMME ON dbo.F_GAMSTOCK.AG_No1 = dbo.F_ARTGAMME.AG_No WHERE (dbo.F_ARTICLE.AR_Gamme1 3) AND (dbo.F_GAMSTOCK.GS_QteSto > 0) AND (dbo.F_ARTICLE.AR_Stat03 '1L') GROUP BY dbo.F_GAMSTOCK.AR_Ref, dbo.F_ARTGAMME.EG_Enumere
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question