[Solved] XML nodes with SQL
Please try the following solution. What we are doing here is called shredding, i.e. converting XML into rectangular/relational format. I am shooting from the hip because DDL and sample data population were not provided. The provided XML is not well-formed due to missing root element, but SQL Server allows to handle XML fragments. We are … Read more