-- SELECT * 
-- INTO #tmpCR
-- FROM creditos
-- WHERE estado ='F'

SELECT * 
INTO #tmp
FROM 
	(SELECT 
		cod_cre=(RTRIM(LTRIM(cr.cod_cre))),
		--ProductName = dbo._fctRR_IncadrareCredite(lcr.descrip, cust.employment_status_s), 
		BalanceRemaining = dbo._fctExcRateAmount(@Data + 1, CAST(cr.cod_moneda AS DECIMAL), @CodMonedaTO, ldb.balance_capital_n),
		grup=gc.group_id_s,
		client=cr.num_cli,
		nume=cust.pri_ape+cust.nombre
-- 	FROM #tmpCR  cr
	FROM creditos cr
	LEFT JOIN groupsXcustomers gc ON gc.num_cli=cr.num_cli
	INNER JOIN customer cust ON cust.num_cli = cr.num_cli
	INNER JOIN _LoansDailyBalance ldb ON ldb.cod_cre = cr.cod_cre 
        WHERE cr.creditos='F'
	) T


SELECT TOP 10 

		grup
		--client		
INTO #tmpex 
		FROM #tmp
		GROUP BY grup
		ORDER BY SUM(BalanceRemaining) DESC
SELECT 
	t1.cod_cre,
	t1.grup,
	t1.client,
	t1.nume,
	t1.BalanceRemaining
FROM #tmp t1
INNER JOIN #tmpex t2 ON #tmpex.grup=#tmp.grup 
--AND #tmpex.client=#tmp.client

--DROP TABLE #tmpCR
DROP TABLE #tmp
DROP TABLE #tmpex