Get XML FILE
Import into 2 Tables in : SQL SERVER 2008
The First Problem : I am not good with XML files , I am good with SQL procs, views, functions, .... I don't mess with XML, but now I need to learn how
The Second Problem : I am having trouble with getting the XML data into a table using SQL Server
The Third Problem : I need to somehow LOOP the embedded envelope data [LineItemList] ... where there is always a [ChildCount] ... and then follows the [LineItems]
There is an ID number : 11213696
And there is an X-Number of Line Items
- 1. Import the Main Data into a Table :
- 2. Import the Line Items into a Second Table with a referencing data point
o Requires adding the [GovtRFQ ID] to the second table for a reference
o Add the Line Item details to fields in a second table
...Below is pulled out of XML File ...
...I have attached the XML file in case you need to see it that way ...