Hi me again, well now i think that i am really looser jejee, how can i
do this whitout pass the table 8 fucking times!!!, i'm sorry but i am
really angry because at this moment i cannot visualize the solution,
help me please:

SELECT
@MAX_HEPE_OUT1 = ISNULL(MAX(Hepe),0),
@MIN_HEPE_OUT1 = ISNULL(MIN(Hepe),0),
@AVG_HEPE_OUT1 = ISNULL(AVG(Hepe),0)
FROM #TMP2_UB_HEPE
WHERE
PMM_DATETIME BETWEEN @dINIT_DATE AND @dEND_DATE_AUX AND
OutputSource = '1'

SELECT
@MAX_HEPE_OUT2 = ISNULL(MAX(Hepe),0),
@MIN_HEPE_OUT2 = ISNULL(MIN(Hepe),0),
@AVG_HEPE_OUT2 = ISNULL(AVG(Hepe),0)
FROM #TMP2_UB_HEPE
WHERE
PMM_DATETIME BETWEEN @dINIT_DATE AND @dEND_DATE_AUX AND
OutputSource = '2'

SELECT
@MAX_HEPE_OUT3 = ISNULL(MAX(Hepe),0),
@MIN_HEPE_OUT3 = ISNULL(MIN(Hepe),0),
@AVG_HEPE_OUT3 = ISNULL(AVG(Hepe),0)
FROM #TMP2_UB_HEPE
WHERE
PMM_DATETIME BETWEEN @dINIT_DATE AND @dEND_DATE_AUX AND
OutputSource = '3'

SELECT
@MAX_HEPE_OUT4 = ISNULL(MAX(Hepe),0),
@MIN_HEPE_OUT4 = ISNULL(MIN(Hepe),0),
@AVG_HEPE_OUT4 = ISNULL(AVG(Hepe),0)
FROM #TMP2_UB_HEPE
WHERE
PMM_DATETIME BETWEEN @dINIT_DATE AND @dEND_DATE_AUX AND
OutputSource = '4'

SELECT
@MAX_HEPE_OUT5 = ISNULL(MAX(Hepe),0),
@MIN_HEPE_OUT5 = ISNULL(MIN(Hepe),0),
@AVG_HEPE_OUT5 = ISNULL(AVG(Hepe),0)
FROM #TMP2_UB_HEPE
WHERE
PMM_DATETIME BETWEEN @dINIT_DATE AND @dEND_DATE_AUX AND
OutputSource = '5'

SELECT
@MAX_HEPE_OUT6 = ISNULL(MAX(Hepe),0),
@MIN_HEPE_OUT6 = ISNULL(MIN(Hepe),0),
@AVG_HEPE_OUT6 = ISNULL(AVG(Hepe),0)
FROM #TMP2_UB_HEPE
WHERE
PMM_DATETIME BETWEEN @dINIT_DATE AND @dEND_DATE_AUX AND
OutputSource = '6'

SELECT
@MAX_HEPE_OUT7 = ISNULL(MAX(Hepe),0),
@MIN_HEPE_OUT7 = ISNULL(MIN(Hepe),0),
@AVG_HEPE_OUT7 = ISNULL(AVG(Hepe),0)
FROM #TMP2_UB_HEPE
WHERE
PMM_DATETIME BETWEEN @dINIT_DATE AND @dEND_DATE_AUX AND
OutputSource = '7'

SELECT
@MAX_HEPE_OUT8 = ISNULL(MAX(Hepe),0),
@MIN_HEPE_OUT8 = ISNULL(MIN(Hepe),0),
@AVG_HEPE_OUT8 = ISNULL(AVG(Hepe),0)
FROM #TMP2_UB_HEPE
WHERE
PMM_DATETIME BETWEEN @dINIT_DATE AND @dEND_DATE_AUX AND
OutputSource = '8'