Es la consulta original sin aplicar ningun filtro ni nada. La consulta la pequé en el live del crm y salió andando, te la dejo aqui:
DECLARE @__doJoin_1 int = 0;
DECLARE @__Anulado_Key_2 nvarchar(1) = N'X';
DECLARE @__ToUpper_3 nvarchar(4000) = N'NO';
SET DEADLOCK_PRIORITY -8;
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', .[COD_BANCO] AS N'Cód. banco', .[DESC_BANCO] AS N'Desc. banco', [m].[SIMBOLO_MONEDA] AS N'Moneda', COALESCE(SUM([s].[IMPORTE_CH]), 0.0) AS N'Importe', .[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 ON [m].[ID_MONEDA] =
.[ID_MONEDA_ALTERNATIVA_HABITUAL]
INNER JOIN [BANCO] AS ON [s].[ID_BANCO] = .[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](@__doJoin_1) AS [c0] ON [c].[ID_CPA01] = [c0].[ID_CPA01]
WHERE ([s].[ESTADO] <> @__Anulado_Key_2) 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) = @__ToUpper_3)
GROUP BY CAST([s].[N_CHEQUE] AS decimal(18,2)), [s].[FECHA_CHEQ], [dbo].[CalcularSemanaDelMes]([s].[FECHA_CHEQ]), .[COD_BANCO], .[DESC_BANCO], [m].[SIMBOLO_MONEDA], .[ID_BANCO]