<Resp ID="1199" WID="425"> <Qtn ID="1" Crt="0" Scr="0"> <Value>Orange</Value> <Value>Yuzu</Value> </Qtn> <Qutn ID="2" Crt="1" Scr="1"> <Value>Soy Milk</Value> </Qtn> </Resp>
I have the above xml. What i need to do is, Converting this data to table format. Basically i need to create a view, which represents the xml data in table format. The XML is well defined format. I need to get these in the following format given below.
Resp ID | WID | Qtn ID | Value | Scr | Crt |
1199 | 425 | 1 | Orange | 0 | 0 |
1199 | 425 | 1 | Yuzu | 0 | 0 |
1199 | 425 | 2 | Soy Milk | 1 | 1 |
I need a select query to get results like the above.
Thank you.