Post reply

Combine data rows getting fields from seperate rows in a query

  • March 31, 2009 at 11:17 pm

    #969619

    Bob Hovious (3/31/2009)

    Flo, I think you have a winner. I don't believe I can improve on that in a single query, since I had begun a similar approach before being distracted by a minor crisis at work. However, the execution plan indicates that it is going to do three separate scans of the the input table. We'll just have to see how it runs against production volumes.

    If unsatisfactory, it might be possible to improve by breaking it into steps, but I don't want to go there if a single query will get the job done.

    Good morning Bob! (it's 7:15 AM here)

    I hope you resolved your issues...

    Have a nice day/night

    Flo

  • April 1, 2009 at 7:29 am

    #969814

    Good morning, Flo!

    I slept well, thanks. Hope your day has been a good one.

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • April 3, 2009 at 10:11 am

    #971708

    Bob and Flo,

    I finally found time to run this against our test system and it works like a perfect.

    THANKS!!!

  • April 3, 2009 at 10:29 am

    #971717

    You're welcome, gnethery, and thanks for taking the time to tell us it works for you.

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • April 3, 2009 at 11:21 am

    #971733

    Thank your for the feedback!

    Greets

    Flo

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply