how to pivot a child table record dynamically?

[Former Member]

Hello All,

I have a table like pressure result that contains the multiple records based on a single parent record. The table structure like-----

s.no               parent id                                     result
1                       10                                           9.5 
2                       10                                           8.2
3                       10                                           7.2
...                     ...                                          ....  
...                    .....                                         ....
20                      10                                           8.9

So now i need result like this:----

column header------1a   1b   2a   2b  3a  3b  4a  4b  5a  5c ............19a   19b    20a   20b
column value-----  9.1  6.2  7.8......................................................9.8   8.7

[MarkCulp]

Take a look at the other questions (and answers) that have been asked about pivot/unpivot - I believe that these answers will tell you how to do it. i.e. you need to construct a SQL statement based on your requirements and then EXECUTE IMMEDIATE the statement to get the result set.

• http://sqlanywhere-forum.sap.com/questions/275/how-do-i-rotate-a-table
• http://sqlanywhere-forum.sap.com/questions/19137/pivotunpivot-in-sybase-iq

HTH