使用Sql Server查询XML数据

I have some xml files that I need to parse and convert to relational data. The data is to be stored in SQL Server. I get the files from different sources and I am running into trouble with one of them because the segment for the purchase order number is repeated. The trouble that I am having is that it creates a duplicate record or row. Here is what the xml looks like.I have some xml files that I need to parse and