Parsing XLM with SQL Server

SQL ServerQuery 21

Thanks in advance for the assistance.

There is some data on a website that I would like to import into a SQL Server database to query:

https://www.thetakeoverpanel.org.uk/disclosure/disclosure-table

The data is also presented in an XML file:

https://www.thetakeoverpanel.org.uk/new/disclosureTable/v3/disclosuretable.xml
https://www.thetakeoverpanel.org.uk/new/disclosureTable/v3/disclosuretable.xsd

I'm having difficulties parsing the data. I think I'd like three tables variables (or temp tables) (Additions, Deletions and MainTable).

Can anyone help?

Thanks,
SQLServerQuery

Yitzhak Khabinsky 27,196 Reputation points

2022-09-07T17:18:42.19+00:00

While asking a question you need to provide a minimal reproducible example:
(1) DDL and sample data population, i.e. CREATE table(s) plus INSERT, T-SQL statements.
(2) What you need to do, i.e. logic, and your attempt implementation of it in T-SQL.
(3) Desired output based on the sample data in the #1 above.
(4) Your SQL Server version (SELECT @@version;)

1 answer

Olaf Helper 47,621 Reputation points

2022-09-08T06:49:40.017+00:00

I'm having difficulties parsing the data.

How does your current XQuery on XML data look like and on which detail do you have issues?
Was this answer helpful?

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Your answer