i have an xml with many rows that i want to convert to a sql table. the xml has repeating elements and i want to retrieve the data so every row in the table will have all the column names (all field names in a row ) and their values .
at the moment i can only get the values to appear in one column.
- i have searched the web but could not find something that workd
here is my XML
1
1
0
2
0
0
No comments:
Post a Comment