Date: Tue, 22 Apr 2008 07:53:06 -0700 (PDT)
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.
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 --