I've a SQL Server database with a table with a XML document, I need to extract the information from this XML document in tables in the same database.
I need two stored procedures like result
1. Stored Procedure for creation of all the tables in the XML documents, this stored procedure will use a document explaining the datatypes and use the description like comment in the script creation.
2. Stored Procedure for extract the XML document in differents tables. The stored procedure will use a XML document to fill the data to all the tables according with the document. I will provide an example how I want to read the xml document.
The base document is in spanish explaining the fiels of all the document and must be used in order to create the tables and comment the stored procedures to be clear.
Hi there, I read your initial requirements and I have some questions regarding your XML documents to SQL project. please send me a message so that we could discuss it further.
Hi! I want to work on this project. I am proficient at excel and can write PSQL query etc. Data cleaning job is best for me. And i work as project manager at Odoo erp devoloper company.