Hi me again, well now i think that i am really looser jejee, how can i
do this whitout pass the table 8 ****ing times!!!, i'm sorry but i am
really angry because at this moment i cannot visualize the solution,
help me please:
SELECT
@[EMAIL PROTECTED]
= ISNULL(MAX(Hepe),0),
@[EMAIL PROTECTED]
= ISNULL(MIN(Hepe),0),
@[EMAIL PROTECTED]
= ISNULL(AVG(Hepe),0)
FROM #TMP2_UB_HEPE
WHERE
PMM_DATETIME BETWEEN @[EMAIL PROTECTED]
AND @[EMAIL PROTECTED]
AND
OutputSource = '1'
SELECT
@[EMAIL PROTECTED]
= ISNULL(MAX(Hepe),0),
@[EMAIL PROTECTED]
= ISNULL(MIN(Hepe),0),
@[EMAIL PROTECTED]
= ISNULL(AVG(Hepe),0)
FROM #TMP2_UB_HEPE
WHERE
PMM_DATETIME BETWEEN @[EMAIL PROTECTED]
AND @[EMAIL PROTECTED]
AND
OutputSource = '2'
SELECT
@[EMAIL PROTECTED]
= ISNULL(MAX(Hepe),0),
@[EMAIL PROTECTED]
= ISNULL(MIN(Hepe),0),
@[EMAIL PROTECTED]
= ISNULL(AVG(Hepe),0)
FROM #TMP2_UB_HEPE
WHERE
PMM_DATETIME BETWEEN @[EMAIL PROTECTED]
AND @[EMAIL PROTECTED]
AND
OutputSource = '3'
SELECT
@[EMAIL PROTECTED]
= ISNULL(MAX(Hepe),0),
@[EMAIL PROTECTED]
= ISNULL(MIN(Hepe),0),
@[EMAIL PROTECTED]
= ISNULL(AVG(Hepe),0)
FROM #TMP2_UB_HEPE
WHERE
PMM_DATETIME BETWEEN @[EMAIL PROTECTED]
AND @[EMAIL PROTECTED]
AND
OutputSource = '4'
SELECT
@[EMAIL PROTECTED]
= ISNULL(MAX(Hepe),0),
@[EMAIL PROTECTED]
= ISNULL(MIN(Hepe),0),
@[EMAIL PROTECTED]
= ISNULL(AVG(Hepe),0)
FROM #TMP2_UB_HEPE
WHERE
PMM_DATETIME BETWEEN @[EMAIL PROTECTED]
AND @[EMAIL PROTECTED]
AND
OutputSource = '5'
SELECT
@[EMAIL PROTECTED]
= ISNULL(MAX(Hepe),0),
@[EMAIL PROTECTED]
= ISNULL(MIN(Hepe),0),
@[EMAIL PROTECTED]
= ISNULL(AVG(Hepe),0)
FROM #TMP2_UB_HEPE
WHERE
PMM_DATETIME BETWEEN @[EMAIL PROTECTED]
AND @[EMAIL PROTECTED]
AND
OutputSource = '6'
SELECT
@[EMAIL PROTECTED]
= ISNULL(MAX(Hepe),0),
@[EMAIL PROTECTED]
= ISNULL(MIN(Hepe),0),
@[EMAIL PROTECTED]
= ISNULL(AVG(Hepe),0)
FROM #TMP2_UB_HEPE
WHERE
PMM_DATETIME BETWEEN @[EMAIL PROTECTED]
AND @[EMAIL PROTECTED]
AND
OutputSource = '7'
SELECT
@[EMAIL PROTECTED]
= ISNULL(MAX(Hepe),0),
@[EMAIL PROTECTED]
= ISNULL(MIN(Hepe),0),
@[EMAIL PROTECTED]
= ISNULL(AVG(Hepe),0)
FROM #TMP2_UB_HEPE
WHERE
PMM_DATETIME BETWEEN @[EMAIL PROTECTED]
AND @[EMAIL PROTECTED]
AND
OutputSource = '8'


|