Re: Anti-pivot
From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Tue, 22 Apr 2008 07:53:06 -0700 (PDT)
Message-ID: <ead3c73c-462c-4e68-b4bb-c78bebd2be59@m73g2000hsh.googlegroups.com>
Date: Tue, 22 Apr 2008 07:53:06 -0700 (PDT)
Message-ID: <ead3c73c-462c-4e68-b4bb-c78bebd2be59@m73g2000hsh.googlegroups.com>
On Apr 22, 5:00 am, Mountain..._at_gmail.com wrote:
> > This works with Oracle 10g XE and Mark's sample data:
>
> This works a treat - many thanks.
>
> Oaf
Urs, yes very nice plus it finishes the job I started since by the time I figured out the minor error I made while writing the query and posted I left out the final pivot of the columns into rows.
- Mark D Powell --