Re: [sqr-users] Transposing rows to columns

["George Jansen" <GJANSEN@aflcio.org>]

If you know how many plan types there potentially are, you can do this as an 
outer join; otherwise on-break logic would as they said be preferred.

>>> "Vaidyanathan, Ramakrishnan (GE, Corporate,  consultant)" 
><ramakrishnan.vaidyanathan@ge.com> 3/8/2007 3:04 PM >>>
Hi All,

        Can anyone help me with the logic on how to display the row values as 
columns from a table. For eg. the table contains the data in the below format

Seq No  Pay End Dt Plan Type Amount
1              Jan           10             $20
1              Jan           10             $0
1              Feb           10            $15
1              Feb           11            $20

If any one of the above first 2 column values (Seq No or Pay End Dt) changes 
then I want to write it as a row else append to the same row. I want the output 
to be written to a file in the following format

Seq No Pay End Date Plan Type-10 Amount Plan Type-11 Amount

1       Jan             10               $20
1          Jan                    10                 $0
1          Feb                    10                 $15               $20

please help me with the logic to do this.

Thanks
Ram

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org 
http://www.sqrug.org/mailman/listinfo/sqr-users


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users