eostic wrote:Ok...first of all, let's make sure that the technique in the "original" issue is fully understood. This is where the column FRED was suggested. The goal is to get you comfortable with the repetition element concept... I hope it was clear. You should have received two rows, as you confirmed.....most of the attributes in your example have identical or blank values --- however, your ItemID's did appear to be unique.
Not sure which columns you are looking at in the XML content below, but for OrderLineTranQuantity there are at least two rows, one with the ReceivedQty of "2" and the other with value "3".
Ernie
Here my keys in the table which u have to load are PrimeLineno and order no.
I tried to follow the same procedure which u suggested earlier "FRED".
But same row is repeated twice.
But i m not getting the second row......
In the above example XML data is at header level and detail.
The detail level will repeat many times.
For example PrimeLine which is 1 and 2.
Can you please help me in this regard.
I tried all the combinations of lowest level but unable to.
solve the issue.
Awaiting for your reply