I am trying (with SQL) to convert an XML type column to a database table. I can do this using XMLTable succesfully until I come across multiple repeating groups.
When I encounter the first node that can repeat I can manage to handle this but if withing this repeating group I encounter another it results in a cartesian join type situation.
What I guess I need is a mechanism for starting at the lowest level and working upwards so that for each of the lowest level rows I get one database row.
Is there any functions that will help with this type of situation?
Many thanks
![[bandito]](/data/assets/smilies/bandito.gif "[bandito] [bandito]")
[blue]DBomrrsm[/blue]
[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]
When I encounter the first node that can repeat I can manage to handle this but if withing this repeating group I encounter another it results in a cartesian join type situation.
What I guess I need is a mechanism for starting at the lowest level and working upwards so that for each of the lowest level rows I get one database row.
Is there any functions that will help with this type of situation?
Many thanks
[blue]DBomrrsm[/blue] [blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]
