-- SELECT * -- INTO #tmpCR-- FROM creditos-- WHERE estado ='F'SELECT *INTO #tmpFROM (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' ) TSELECT TOP 10 grup --client INTO #tmpex FROM #tmp GROUP BY grup ORDER BY SUM(BalanceRemaining) DESCSELECT t1.cod_cre, t1.grup, t1.client, t1.nume, t1.BalanceRemainingFROM #tmp t1INNER JOIN #tmpex t2 ON #tmpex.grup=#tmp.grup --AND #tmpex.client=#tmp.client--DROP TABLE #tmpCRDROP TABLE #tmpDROP TABLE #tmpex