Home Forums Programming XML Extract XML column to insert into table RE: Extract XML column to insert into table

  • Hi Eirikur,

    I think I owe you a large drink next time I see you!

    I had started working on the basis yesterday that you had to split the query in two - I had the one for the "header" information, but couldn't get the "repeating detail" to work. I either had 2, 23, or 64 rows. As there were 21 in the "header" I was aiming for 32! Oops

    You second query certainly only produces the 32 rows. The tag is coming through incorrectly on the real data, but that's an easy fix. I will then test against the 13 person record.

    Many thanks,

    Rodney