XML help

[yosiasz]

Handle XML to SQL output

Hello sql expert, I am working to extract below xml file using sql query. I can extract them out if the element is single but the issue I am having is I have 2 Products' element which is now return the same value. Here is my XML file that I am using: [04] Note: below is the xml in text format: <Subcategories> <Subcategory ProductSubcategoryID = "18" Name="Bib-Shorts"> <Products> <Product> <ProductID type="1">855</ProductID> <ProductID type="2">676</ProductID> <Name>Men's Bib-S…