KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
Could someone show me some TSQL to use to query an xml file as if it were a table? The file is on the server, "C:\xmlfile.xml" And contains <ArrayOfSpangemansFilter xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <SpangemansFilter> <FilterID>1219</FilterID> <Name>Fred</Name> <Code>510</Code> <Department>N</Department> <Number>305327</Number> </SpangemansFilter> <SpangemansFilter> <FilterID>3578</FilterID> <Name>Gary</Name> <Code>001</Code> <Department>B</Department> <Number>0692690</Number> </SpangemansFilter> <SpangemansFilter> <FilterID>3579</FilterID> <Name>George</Name> <Code>001</Code> <Department>X</Department> <Number>35933</Number> </SpangemansFilter> </ArrayOfSpangemansFilter> Example output I am after FilterID |Name |Code |Department |Number ------------------------------------------------------------------- 1219 |Fred |510 |N |305327 3578 |Gary |001 |B |0692690 3579 |George |001 |X |35933
Tags (comma-separated)
Save Edits
Cancel