I have a table with two columns: OID and Cumulative (witch is the same type as OID)
Each OID can have one or more Cumulatives.
Example of data:
OID Cumulative
167 292
167 294
167 296
168 292
169 302
169 304
The cumulation of each OID don't stop at one cumulation, but can be endless (theoretical).
Example: 167->292->590
So the table would have on more row:
OID Cumulative
295 505
I would like to represent this strucuture in a tree view and I'm looking for a query that could give me a table with this structure:
OID Cumul1 Cumul2 Cuml3 Cuml4 .... Cumuln
in the way I can read the row and have as many child nodes as I have values in the columns. The number of columns depends on the row with most cumulations.
How can I do the query?
Is there a better way as my table with n columns?
Thanks for suggestions
Your sample data is confusing..Can you fix it. Let us know the sample output from the input (sample data) you provided.
No comments:
Post a Comment