-- Cuotas mora
SELECT * FROM dbo.Recibos
WHERE CONVERT(VARCHAR, FechaCreacion, 112) = 20220420
AND Contrato_ContratoId IN (
SELECT cc.Contrato_ContratoId FROM dbo.ContratoCuotas cc
INNER JOIN dbo.Contratos co ON co.ContratoId = cc.Contrato_ContratoId
WHERE CONVERT(VARCHAR,cc.FechaCuota,112) < CONVERT(VARCHAR,GETDATE(),112)
AND CONVERT(VARCHAR,cc.FechaPagada,112) = CONVERT(VARCHAR,GETDATE(),112)
AND CONVERT(VARCHAR,cc.FechaCuota,112) <= CONVERT(VARCHAR,co.FechaUltimaCuota,112)
)