gistfile1.txt

SELECT top 20  NOMEEMP [EMPRESA] , DCRCC [CENTRO_DE_CUSTO] , CASE WHEN CODINTMLGDD = 6 THEN 'LA' ELSE 'NA' END [TIPO_SMS] , SUM(ISNULL(QTDMLGDD,1)) [VOLUME_PROCESSADO] , SUM(CASE WHEN CODMLGDDSTS IN (12,5) THEN ISNULL(QTDMLGDD,1) ELSE 0 END) [VOLUME_TARIFADO] FROM  tbl_mailling_dado MDD WITH (NOLOCK)  INNER JOIN tbl_mailling MLG WITH (NOLOCK) ON MDD.codmlg = MLG.codmlg INNER JOIN tbl_empresa EMP WITH (NOLOCK) ON MDD.codemp = EMP.codemp  INNER JOIN tbl_centro_custo CC WITH (NOLOCK) ON MLG.codcc = CC.codcc WHERE  CODMLGDDSTS IN (12,5) AND (DATAENVMLGDD IS NULL AND DATAINIMLG BETWEEN '2015-11-01 00:00:00' AND '2015-12-01 00:00:00') OR (DATAENVMLGDD BETWEEN '2015-11-01 00:00:00' AND '2015-12-01 00:00:00') GROUP BY  NOMEEMP,   DCRCC,    CODINTMLGDD,   CASE WHEN CODINTMLGDD = 6 THEN 'LA' ELSE 'NA' END