SELECT CAST([s].[N_CHEQUE] AS decimal(18,2)) AS [NRO_DE_CHEQUE], [s].[FECHA_CHEQ] AS N'Fecha del cheque', [dbo].[CalcularSemanaDelMes]([s].[FECHA_CHEQ]) AS N'Semana / mes', [b].[COD_BANCO] AS N'Cód. banco', [b].[DESC_BANCO] AS N'Desc. banco', [m].[SIMBOLO_MONEDA] AS N'Moneda', COALESCE(SUM([s].[IMPORTE_CH]), 0.0) AS N'Importe', [b].[ID_BANCO]

FROM [SBA15] AS [s]

LEFT JOIN [CPA01] AS [c] ON [s].[PROVEEDOR] = [c].[COD_PROVEE]

INNER JOIN [SBA01] AS [s0] ON [s].[CTA_EMISIO] = [s0].[COD_CTA]

INNER JOIN [MONEDA] AS [m] ON [s0].[ID_MONEDA] = [m].[ID_MONEDA]

LEFT JOIN [PARAMETRO_GBL] AS [p] ON [m].[ID_MONEDA] = [p].[ID_MONEDA_ALTERNATIVA_HABITUAL]

INNER JOIN [BANCO] AS [b] ON [s].[ID_BANCO] = [b].[ID_BANCO]

LEFT JOIN [SBA05] AS [s1] ON (((([s].[N_COMP_EMI] = [s1].[N_COMP]) AND ([s].[T_COMP_EMI] = [s1].[COD_COMP])) AND ([s].[CTA_EMISIO] = [s1].[COD_CTA])) AND ([s].[BARRA_EMI] = [s1].[BARRA])) AND ([s].[RENGLON_EMI] = [s1].[RENGLON])

LEFT JOIN [SBA04] AS [s2] ON (([s1].[N_COMP] = [s2].[N_COMP]) AND ([s1].[COD_COMP] = [s2].[COD_COMP])) AND (([s1].[BARRA] = [s2].[BARRA]) OR ([s1].[BARRA] IS NULL AND [s2].[BARRA] IS NULL))

LEFT JOIN [dbo].[ClasificadorCPA01](0) AS [c0] ON [c].[ID_CPA01] = [c0].[ID_CPA01]

WHERE ([s].[ESTADO] <> 'X') AND (UPPER(CASE

    WHEN [s].[M_CONC_EMI] = CAST(0 AS bit) THEN N'No'

    WHEN [s].[M_CONC_EMI] = CAST(1 AS bit) THEN N'Si'

    ELSE N''

END) = 'NO')

GROUP BY CAST([s].[N_CHEQUE] AS decimal(18,2)), [s].[FECHA_CHEQ], [dbo].[CalcularSemanaDelMes]([s].[FECHA_CHEQ]), [b].[COD_BANCO], [b].[DESC_BANCO], [m].[SIMBOLO_MONEDA], [b].[ID_BANCO]