Tech
Forums
Jobs
Books
Events
Videos
Conference
Annual Conference
Bcrypt
Ai Conference
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
1
Answer
Convert xml to table in sql
Ask a question
Ask a question
Upload Source Code:
Select only zip and rar file.
Prasant Jinaga
12y
2.1k
1
Reply
Hi,
I have an xml in following format,
I want to convert the below XML to the table in sql.the output has to be something like this.
Does anyone done this before??
---Output----
ExternalProvider_ID
ZZZZZ00003
ZZZZZ00006
ZZZZZ00009
ZZZZZ0000E
-----XML----
<NewDataSet>
<Table1>
<TableID>ZZZZZ00003</TableID>
</Table1>
<Table1>
<TableID>ZZZZZ00006</TableID>
</Table1>
<Table1>
<TableID>ZZZZZ00009</TableID>
</Table1>
<Table1>
<TableID>ZZZZZ0000E</TableID>
</Table1>
</NewDataSet>
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
Co-related sub query and nested sub query in SQL
tell me about select query