SELECT < first set of fields > FROM mytable UNION ALL SELECT < second set of fields > FROM mytable ORDER BY question>
>qustion countof1 pctof2 countof2 pctof2......countof17 pctof17 >q1 6 2.1 5 1.9 8 2.5 >q2 4 1.6 9 3.2 ....................... >. >. >q17 14 9.4 4 1.6 9 3.2 > >at the new table or cursor >qustion countof1 countof2 ......countof17 >q1 6 5 8 > 2.1 1.9 2.5 >q2 4 9 .................. > 1.6 3.2 ................ >. >. >q17 14 4 9 > 9.4 1.6 3.2 > > > >>thanks