Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Sybase > A BETTER QUERY
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 5 Topic 2450 of 2512
Post > Topic >>

A BETTER QUERY

by Jorge Reyes <jorg_reyes@[EMAIL PROTECTED] > Apr 22, 2008 at 04:05 PM

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'
 




 5 Posts in Topic:
A BETTER QUERY
Jorge Reyes <jorg_reye  2008-04-22 16:05:21 
Re: A BETTER QUERY
--CELKO-- <jcelko212@[  2008-04-23 09:28:41 
Re: A BETTER QUERY
bret@[EMAIL PROTECTED]   2008-04-23 11:46:14 
Re: A BETTER QUERY
Jorge Reyes <jorg_reye  2008-04-23 15:28:01 
Re: A BETTER QUERY
bret@[EMAIL PROTECTED]   2008-04-24 11:02:52 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Thu Jul 24 1:36:52 CDT 2008.