Assuming that assigning the values to local variables is im****tant,
something like the following might be used:
SELECT
@[EMAIL PROTECTED]
= COALESCE( MAX( CASE when Outputsource = 1 then Hepe
else <minvalue> end ),0),
@[EMAIL PROTECTED]
= COALESCE( MIN( CASE when Outputsource = 1 then
Hepeelse <minvalue> end ),0),
@[EMAIL PROTECTED]
= COALESCE( AVG( CASE when Outputsource = 1 then
Hepeelse <minvalue> end ),0)
@[EMAIL PROTECTED]
= COALESCE( MAX( CASE when Outputsource = 1 then
Hepeelse <minvalue> end ),0),
@[EMAIL PROTECTED]
= COALESCE( MIN( CASE when Outputsource = 1 then
Hepeelse <minvalue> end ),0),
@[EMAIL PROTECTED]
= COALESCE( AVG( CASE when Outputsource = 1 then
Hepeelse <minvalue> end ),0)
@[EMAIL PROTECTED]
= COALESCE( MAX( CASE when Outputsource = 1 then
Hepeelse <minvalue> end ),0),
@[EMAIL PROTECTED]
= COALESCE( MIN( CASE when Outputsource = 1 then
Hepeelse <minvalue> end ),0),
@[EMAIL PROTECTED]
= COALESCE( AVG( CASE when Outputsource = 1 then
Hepeelse <minvalue> end ),0)
@[EMAIL PROTECTED]
= COALESCE( MAX( CASE when Outputsource = 1 then
Hepeelse <minvalue> end ),0),
@[EMAIL PROTECTED]
= COALESCE( MIN( CASE when Outputsource = 1 then
Hepeelse <minvalue> end ),0),
@[EMAIL PROTECTED]
= COALESCE( AVG( CASE when Outputsource = 1 then
Hepeelse <minvalue> end ),0)
@[EMAIL PROTECTED]
= COALESCE( MAX( CASE when Outputsource = 1 then
Hepeelse <minvalue> end ),0),
@[EMAIL PROTECTED]
= COALESCE( MIN( CASE when Outputsource = 1 then
Hepeelse <minvalue> end ),0),
@[EMAIL PROTECTED]
= COALESCE( AVG( CASE when Outputsource = 1 then
Hepeelse <minvalue> end ),0)
@[EMAIL PROTECTED]
= COALESCE( MAX(CASE when Outputsource = 1 then
Hepeelse <minvalue> end ),0),
@[EMAIL PROTECTED]
= COALESCE( MIN( CASE when Outputsource = 1 then
Hepeelse <minvalue> end ),0),
@[EMAIL PROTECTED]
= COALESCE( AVG( CASE when Outputsource = 1 then
Hepeelse <minvalue> end ),0)
@[EMAIL PROTECTED]
= COALESCE( MAX( CASE when Outputsource = 1 then
Hepeelse <minvalue> end ),0),
@[EMAIL PROTECTED]
= COALESCE( MIN( CASE when Outputsource = 1 then
Hepeelse <minvalue> end ),0),
@[EMAIL PROTECTED]
= COALESCE( AVG( CASE when Outputsource = 1 then
Hepeelse <minvalue> end ),0)
@[EMAIL PROTECTED]
= COALESCE( MAX( CASE when Outputsource = 1 then
Hepeelse <minvalue> end ),0),
@[EMAIL PROTECTED]
= COALESCE( MIN( CASE when Outputsource = 1 then
Hepeelse <minvalue> end ),0),
@[EMAIL PROTECTED]
= COALESCE( AVG( CASE when Outputsource = 1 then
Hepeelse <minvalue> end ),0)
FROM #TMP2_UB_HEPE
WHERE
PMM_DATETIME BETWEEN @[EMAIL PROTECTED]
AND @[EMAIL PROTECTED]
|
