Hi,
I've following XML File Structure:
<?xml version="1.0" encoding="ISO-8859-1"?>
<MenuSystem>
<Definition>
<Menue label="Main">
<File label="A">
<File label="B">
<File label="C">
<File label="D">
<Prog label="first"/>
<Prog label="second"/>
<Prog label="third"/>
</File>
<File label="E">
<Prog label="1"/>
<Prog label="2"/>
<Prog label="3"/>
</File>
</File>
<File label="F">
<File label="G">
<Prog label="AA"/>
<Prog label="BB"/>
</File>
<File label="H">
<Prog label="CC"/>
</File>
File label="I">
<Prog label="DD"/>
<Prog label="EE"/>
</File>
</File>
</File>
</File>
</Menue>
</Definition>
</MenuSystem>
what I need is a sql query to get following columns:
ID Parent_ID Tag Value
----------------------------------------------------------------------------------------
1 0 Menue Main
2 1 File A
3 2 File B
4 3 File C
5 4 File D
6 5 Prog first
7 5 Prog second