Below is the XML that I'm using.  I'm having 2 problems:

Problem 1- I can't figure out how to query the data witht the namespace in the document even with the use...

Ok, thanks for the reply.  I realize it's not the way it should be which is why I am asking for help here.  I haven't been able to figure out...

Hi.  Below is the query I'm using but still getting no results 🙁
    SELECT
        HDR.DATA.value('(ParentAAIAID/text())[1]','VARCHAR(100)')as ParentAAIAID
        ,HDR.DATA.value('(BrandOwnerAAIAID/text())[1]','VARCHAR(100)')as BrandOwnerAAIAID

        ,APP.DATA.value('(BaseItemID/@id)[1]' ,'varchar(50)'  ) AS BaseItemID
        ,APP.DATA.value('(PartNumber/@id)[1]' ,'varchar(50)'  ) AS PartNumber
from...

Thank you for the reply.  Yes I accidentally copied just the first few rows which is why the ending tags are gone.  I followed your advice on adding wildcards, but...

Hello Again.  I'm having a similar problem with a differnt xml file where I again need to import Header and Child info and I'm not getting any records returned.  If you can...

Thank you again!  FYI, that didnt work, but I modified it to include a 2nd cross apply join which looks OK (the results and record count are accurate).  I'm hoping this will...

Yes, you are correct.  It works now.  My LAST issue with this file is that I need to include and repeat the Header information for each record.  Below is the...

Hello again.  I'm having trouble linking the header info to the detail.  I need to import some of the Header attributes as well.  XML and Query are below:

<ACES...

Thank you so much.  This works perfectly!

Sorry, one more small question.  Some of the xml files I'll be importing are quite large and storing all the xml in a variable takes several minutes and consumes lots of resources. ...

This works!  Thank you very much!

If someone could please post a query on how I can retrieve all the attributes and elements in the XML file, it would be much appreciated.  I took a stab...