SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE FUNCTION [dbo].[XMLTable](@x XML)  
RETURNS TABLE 
AS RETURN 
WITH cte AS (  
SELECT 
        1 AS lvl,  
        x.value('local-name(.)','NVARCHAR(MAX)') AS Name,  
        CAST(NULL AS NVARCHAR(MAX)) AS ParentName, 
        CAST(1 AS INT) AS ParentPosition, 
        CAST(N'Element' AS NVARCHAR(20)) AS NodeType,  
        x.value('local-name(.)','NVARCHAR(MAX)') AS FullPath,  
        x.value('local-name(.)','NVARCHAR(MAX)')  
        + N'[' 
        + CAST(ROW_NUMBER() OVER(ORDER BY (SELECT 1)) AS NVARCHAR)  
        + N']' AS XPath,  
        ROW_NUMBER() OVER(ORDER BY (SELECT 1)) AS Position, 
        x.value('local-name(.)','NVARCHAR(MAX)') AS Tree,  
        x.value('text()[1]','NVARCHAR(MAX)') AS Value,  
        x.query('.') AS this,         
        x.query('*') AS t,  
        CAST(CAST(1 AS VARBINARY(4)) AS VARBINARY(MAX)) AS Sort,  
        CAST(1 AS INT) AS ID  
FROM @x.nodes('/*') a(x)  
UNION ALL 
SELECT 
        p.lvl + 1 AS lvl,  
        c.value('local-name(.)','NVARCHAR(MAX)') AS Name,  
        CAST(p.Name AS NVARCHAR(MAX)) AS ParentName, 
    CAST(p.Position AS INT) AS ParentPosition, 
        CAST(N'Element' AS NVARCHAR(20)) AS NodeType,  
        CAST(p.FullPath + N'/' + c.value('local-name(.)','NVARCHAR(MAX)') AS NVARCHAR(MAX)) AS FullPath,  
        CAST(p.XPath + N'/'+ c.value('local-name(.)','NVARCHAR(MAX)')+ N'['+ CAST(ROW_NUMBER() OVER(PARTITION BY c.value('local-name(.)','NVARCHAR(MAX)') 
        ORDER BY (SELECT 1)) AS NVARCHAR)+ N']' AS NVARCHAR(MAX)) AS XPath,  
        ROW_NUMBER() OVER(PARTITION BY c.value('local-name(.)','NVARCHAR(MAX)')
        ORDER BY (SELECT 1)) AS Position, 
        CAST( SPACE(2 * p.lvl - 1) + N'|' + REPLICATE(N'-', 1) + c.value('local-name(.)','NVARCHAR(MAX)') AS NVARCHAR(MAX)) AS Tree,  
        CAST( c.value('text()[1]','NVARCHAR(MAX)') AS NVARCHAR(MAX) ) AS Value, c.query('.') AS this,  
        c.query('*') AS t,  
        CAST(p.Sort + CAST( (lvl + 1) * 1024 + (ROW_NUMBER() OVER(ORDER BY (SELECT 1)) * 2) AS VARBINARY(4)) AS VARBINARY(MAX) ) AS Sort,  
        CAST((lvl + 1) * 1024 + (ROW_NUMBER() OVER(ORDER BY (SELECT 1)) * 2) AS INT)  
FROM cte p  
CROSS APPLY p.t.nodes('*') b(c)), cte2 AS (  
                                            SELECT 
                                            lvl AS Depth,  
                                            Name AS NodeName,  
                                            ParentName, 
                                            ParentPosition, 
                                            NodeType,  
                                            FullPath,  
                                            XPath,  
                                            Position, 
                                            Tree AS TreeView,  
                                            Value,  
                                            this AS XMLData,  
                                            Sort, ID  
                                            FROM cte  
UNION ALL 
SELECT 
        p.lvl,  
        x.value('local-name(.)','NVARCHAR(MAX)'),  
        p.Name, 
        p.Position, 
        CAST(N'Attribute' AS NVARCHAR(20)),  
        p.FullPath + N'/@' + x.value('local-name(.)','NVARCHAR(MAX)'),  
        p.XPath + N'/@' + x.value('local-name(.)','NVARCHAR(MAX)'),  
        1, 
        SPACE(2 * p.lvl - 1) + N'|' + REPLICATE('-', 1)  
        + N'@' + x.value('local-name(.)','NVARCHAR(MAX)'),  
        x.value('.','NVARCHAR(MAX)'),  
        NULL,  
        p.Sort,  
        p.ID + 1  
FROM cte p  
CROSS APPLY this.nodes('/*/@*') a(x)  
)  
SELECT 
        ROW_NUMBER() OVER(ORDER BY Sort, ID) AS ID,  
        ParentName, ParentPosition,Depth, NodeName, Position,   
        NodeType, FullPath, XPath, TreeView, Value, XMLData 
FROM cte2

-- https://www.service-architecture.com/articles/object-oriented-databases/xml-file-for-complex-data.html

select *
from dbo.XMLTable('
<catalog>
   <product description="Cardigan Sweater" product_image="cardigan.jpg">
      <catalog_item gender="Men''s">
         <item_number>QWZ5671</item_number>
         <price>39.95</price>
         <size description="Medium">
            <color_swatch image="red_cardigan.jpg">Red</color_swatch>
            <color_swatch image="burgundy_cardigan.jpg">Burgundy</color_swatch>
         </size>
         <size description="Large">
            <color_swatch image="red_cardigan.jpg">Red</color_swatch>
            <color_swatch image="burgundy_cardigan.jpg">Burgundy</color_swatch>
         </size>
      </catalog_item>
      <catalog_item gender="Women''s">
         <item_number>RRX9856</item_number>
         <price>42.50</price>
         <size description="Small">
            <color_swatch image="red_cardigan.jpg">Red</color_swatch>
            <color_swatch image="navy_cardigan.jpg">Navy</color_swatch>
            <color_swatch image="burgundy_cardigan.jpg">Burgundy</color_swatch>
         </size>
         <size description="Medium">
            <color_swatch image="red_cardigan.jpg">Red</color_swatch>
            <color_swatch image="navy_cardigan.jpg">Navy</color_swatch>
            <color_swatch image="burgundy_cardigan.jpg">Burgundy</color_swatch>
            <color_swatch image="black_cardigan.jpg">Black</color_swatch>
         </size>
         <size description="Large">
            <color_swatch image="navy_cardigan.jpg">Navy</color_swatch>
            <color_swatch image="black_cardigan.jpg">Black</color_swatch>
         </size>
         <size description="Extra Large">
            <color_swatch image="burgundy_cardigan.jpg">Burgundy</color_swatch>
            <color_swatch image="black_cardigan.jpg">Black</color_swatch>
         </size>
      </catalog_item>
   </product>
</catalog>
')

ID	ParentName	ParentPosition	Depth	NodeName	Position	NodeType	FullPath	XPath	TreeView	Value	XMLData
1	null	1	1	catalog	1	Element	catalog	catalog[1]	catalog	null	<?xml version="1.0" encoding="utf-16"?> <catalog> <product description="Cardigan Sweater" product_image="cardigan.jpg"> <catalog_item gender="Men's"> <item_number>QWZ5671</item_number> <price>39.95</price> <size description="Medium"> <color_swatch image="red_cardigan.jpg">Red</color_swatch> <color_swatch image="burgundy_cardigan.jpg">Burgundy</color_swatch> </size> <size description="Large"> <color_swatch image="red_cardigan.jpg">Red</color_swatch> <color_swatch image="burgundy_cardigan.jpg">Burgundy</color_swatch> </size> </catalog_item> <catalog_item gender="Women's"> <item_number>RRX9856</item_number> <price>42.50</price> <size description="Small"> <color_swatch image="red_cardigan.jpg">Red</color_swatch> <color_swatch image="navy_cardigan.jpg">Navy</color_swatch> <color_swatch image="burgundy_cardigan.jpg">Burgundy</color_swatch> </size> <size description="Medium"> <color_swatch image="red_cardigan.jpg">Red</color_swatch> <color_swatch image="navy_cardigan.jpg">Navy</color_swatch> <color_swatch image="burgundy_cardigan.jpg">Burgundy</color_swatch> <color_swatch image="black_cardigan.jpg">Black</color_swatch> </size> <size description="Large"> <color_swatch image="navy_cardigan.jpg">Navy</color_swatch> <color_swatch image="black_cardigan.jpg">Black</color_swatch> </size> <size description="Extra Large"> <color_swatch image="burgundy_cardigan.jpg">Burgundy</color_swatch> <color_swatch image="black_cardigan.jpg">Black</color_swatch> </size> </catalog_item> </product> </catalog>
2	catalog	1	2	product	1	Element	catalog/product	catalog[1]/product[1]	\|-product	null	<?xml version="1.0" encoding="utf-16"?> <product description="Cardigan Sweater" product_image="cardigan.jpg"> <catalog_item gender="Men's"> <item_number>QWZ5671</item_number> <price>39.95</price> <size description="Medium"> <color_swatch image="red_cardigan.jpg">Red</color_swatch> <color_swatch image="burgundy_cardigan.jpg">Burgundy</color_swatch> </size> <size description="Large"> <color_swatch image="red_cardigan.jpg">Red</color_swatch> <color_swatch image="burgundy_cardigan.jpg">Burgundy</color_swatch> </size> </catalog_item> <catalog_item gender="Women's"> <item_number>RRX9856</item_number> <price>42.50</price> <size description="Small"> <color_swatch image="red_cardigan.jpg">Red</color_swatch> <color_swatch image="navy_cardigan.jpg">Navy</color_swatch> <color_swatch image="burgundy_cardigan.jpg">Burgundy</color_swatch> </size> <size description="Medium"> <color_swatch image="red_cardigan.jpg">Red</color_swatch> <color_swatch image="navy_cardigan.jpg">Navy</color_swatch> <color_swatch image="burgundy_cardigan.jpg">Burgundy</color_swatch> <color_swatch image="black_cardigan.jpg">Black</color_swatch> </size> <size description="Large"> <color_swatch image="navy_cardigan.jpg">Navy</color_swatch> <color_swatch image="black_cardigan.jpg">Black</color_swatch> </size> <size description="Extra Large"> <color_swatch image="burgundy_cardigan.jpg">Burgundy</color_swatch> <color_swatch image="black_cardigan.jpg">Black</color_swatch> </size> </catalog_item> </product>
3	product	1	2	description	1	Attribute	catalog/product/@description	catalog[1]/product[1]/@description	\|-@description	Cardigan Sweater	null
4	product	1	2	product_image	1	Attribute	catalog/product/@product_image	catalog[1]/product[1]/@product_image	\|-@product_image	cardigan.jpg	null
5	product	1	3	catalog_item	1	Element	catalog/product/catalog_item	catalog[1]/product[1]/catalog_item[1]	\|-catalog_item	null	<?xml version="1.0" encoding="utf-16"?> <catalog_item gender="Men's"> <item_number>QWZ5671</item_number> <price>39.95</price> <size description="Medium"> <color_swatch image="red_cardigan.jpg">Red</color_swatch> <color_swatch image="burgundy_cardigan.jpg">Burgundy</color_swatch> </size> <size description="Large"> <color_swatch image="red_cardigan.jpg">Red</color_swatch> <color_swatch image="burgundy_cardigan.jpg">Burgundy</color_swatch> </size> </catalog_item>
6	catalog_item	1	3	gender	1	Attribute	catalog/product/catalog_item/@gender	catalog[1]/product[1]/catalog_item[1]/@gender	\|-@gender	Men's	null
7	catalog_item	1	4	item_number	1	Element	catalog/product/catalog_item/item_number	catalog[1]/product[1]/catalog_item[1]/item_number[1]	\|-item_number	QWZ5671	<?xml version="1.0" encoding="utf-16"?> <item_number>QWZ5671</item_number>
8	catalog_item	1	4	price	1	Element	catalog/product/catalog_item/price	catalog[1]/product[1]/catalog_item[1]/price[1]	\|-price	39.95	<?xml version="1.0" encoding="utf-16"?> <price>39.95</price>
9	catalog_item	1	4	size	1	Element	catalog/product/catalog_item/size	catalog[1]/product[1]/catalog_item[1]/size[1]	\|-size	null	<?xml version="1.0" encoding="utf-16"?> <size description="Medium"> <color_swatch image="red_cardigan.jpg">Red</color_swatch> <color_swatch image="burgundy_cardigan.jpg">Burgundy</color_swatch> </size>
10	size	1	4	description	1	Attribute	catalog/product/catalog_item/size/@description	catalog[1]/product[1]/catalog_item[1]/size[1]/@description	\|-@description	Medium	null
11	size	1	5	color_swatch	1	Element	catalog/product/catalog_item/size/color_swatch	catalog[1]/product[1]/catalog_item[1]/size[1]/color_swatch[1]	\|-color_swatch	Red	<?xml version="1.0" encoding="utf-16"?> <color_swatch image="red_cardigan.jpg">Red</color_swatch>
12	color_swatch	1	5	image	1	Attribute	catalog/product/catalog_item/size/color_swatch/@image	catalog[1]/product[1]/catalog_item[1]/size[1]/color_swatch[1]/@image	\|-@image	red_cardigan.jpg	null
13	size	1	5	color_swatch	2	Element	catalog/product/catalog_item/size/color_swatch	catalog[1]/product[1]/catalog_item[1]/size[1]/color_swatch[2]	\|-color_swatch	Burgundy	<?xml version="1.0" encoding="utf-16"?> <color_swatch image="burgundy_cardigan.jpg">Burgundy</color_swatch>
14	color_swatch	2	5	image	1	Attribute	catalog/product/catalog_item/size/color_swatch/@image	catalog[1]/product[1]/catalog_item[1]/size[1]/color_swatch[2]/@image	\|-@image	burgundy_cardigan.jpg	null
15	catalog_item	1	4	size	2	Element	catalog/product/catalog_item/size	catalog[1]/product[1]/catalog_item[1]/size[2]	\|-size	null	<?xml version="1.0" encoding="utf-16"?> <size description="Large"> <color_swatch image="red_cardigan.jpg">Red</color_swatch> <color_swatch image="burgundy_cardigan.jpg">Burgundy</color_swatch> </size>
16	size	2	4	description	1	Attribute	catalog/product/catalog_item/size/@description	catalog[1]/product[1]/catalog_item[1]/size[2]/@description	\|-@description	Large	null
17	size	2	5	color_swatch	1	Element	catalog/product/catalog_item/size/color_swatch	catalog[1]/product[1]/catalog_item[1]/size[2]/color_swatch[1]	\|-color_swatch	Red	<?xml version="1.0" encoding="utf-16"?> <color_swatch image="red_cardigan.jpg">Red</color_swatch>
18	color_swatch	1	5	image	1	Attribute	catalog/product/catalog_item/size/color_swatch/@image	catalog[1]/product[1]/catalog_item[1]/size[2]/color_swatch[1]/@image	\|-@image	red_cardigan.jpg	null
19	size	2	5	color_swatch	2	Element	catalog/product/catalog_item/size/color_swatch	catalog[1]/product[1]/catalog_item[1]/size[2]/color_swatch[2]	\|-color_swatch	Burgundy	<?xml version="1.0" encoding="utf-16"?> <color_swatch image="burgundy_cardigan.jpg">Burgundy</color_swatch>
20	color_swatch	2	5	image	1	Attribute	catalog/product/catalog_item/size/color_swatch/@image	catalog[1]/product[1]/catalog_item[1]/size[2]/color_swatch[2]/@image	\|-@image	burgundy_cardigan.jpg	null
21	product	1	3	catalog_item	2	Element	catalog/product/catalog_item	catalog[1]/product[1]/catalog_item[2]	\|-catalog_item	null	<?xml version="1.0" encoding="utf-16"?> <catalog_item gender="Women's"> <item_number>RRX9856</item_number> <price>42.50</price> <size description="Small"> <color_swatch image="red_cardigan.jpg">Red</color_swatch> <color_swatch image="navy_cardigan.jpg">Navy</color_swatch> <color_swatch image="burgundy_cardigan.jpg">Burgundy</color_swatch> </size> <size description="Medium"> <color_swatch image="red_cardigan.jpg">Red</color_swatch> <color_swatch image="navy_cardigan.jpg">Navy</color_swatch> <color_swatch image="burgundy_cardigan.jpg">Burgundy</color_swatch> <color_swatch image="black_cardigan.jpg">Black</color_swatch> </size> <size description="Large"> <color_swatch image="navy_cardigan.jpg">Navy</color_swatch> <color_swatch image="black_cardigan.jpg">Black</color_swatch> </size> <size description="Extra Large"> <color_swatch image="burgundy_cardigan.jpg">Burgundy</color_swatch> <color_swatch image="black_cardigan.jpg">Black</color_swatch> </size> </catalog_item>
22	catalog_item	2	3	gender	1	Attribute	catalog/product/catalog_item/@gender	catalog[1]/product[1]/catalog_item[2]/@gender	\|-@gender	Women's	null
23	catalog_item	2	4	item_number	1	Element	catalog/product/catalog_item/item_number	catalog[1]/product[1]/catalog_item[2]/item_number[1]	\|-item_number	RRX9856	<?xml version="1.0" encoding="utf-16"?> <item_number>RRX9856</item_number>
24	catalog_item	2	4	price	1	Element	catalog/product/catalog_item/price	catalog[1]/product[1]/catalog_item[2]/price[1]	\|-price	42.50	<?xml version="1.0" encoding="utf-16"?> <price>42.50</price>
25	catalog_item	2	4	size	1	Element	catalog/product/catalog_item/size	catalog[1]/product[1]/catalog_item[2]/size[1]	\|-size	null	<?xml version="1.0" encoding="utf-16"?> <size description="Small"> <color_swatch image="red_cardigan.jpg">Red</color_swatch> <color_swatch image="navy_cardigan.jpg">Navy</color_swatch> <color_swatch image="burgundy_cardigan.jpg">Burgundy</color_swatch> </size>
26	size	1	4	description	1	Attribute	catalog/product/catalog_item/size/@description	catalog[1]/product[1]/catalog_item[2]/size[1]/@description	\|-@description	Small	null
27	size	1	5	color_swatch	1	Element	catalog/product/catalog_item/size/color_swatch	catalog[1]/product[1]/catalog_item[2]/size[1]/color_swatch[1]	\|-color_swatch	Red	<?xml version="1.0" encoding="utf-16"?> <color_swatch image="red_cardigan.jpg">Red</color_swatch>
28	color_swatch	1	5	image	1	Attribute	catalog/product/catalog_item/size/color_swatch/@image	catalog[1]/product[1]/catalog_item[2]/size[1]/color_swatch[1]/@image	\|-@image	red_cardigan.jpg	null
29	size	1	5	color_swatch	2	Element	catalog/product/catalog_item/size/color_swatch	catalog[1]/product[1]/catalog_item[2]/size[1]/color_swatch[2]	\|-color_swatch	Navy	<?xml version="1.0" encoding="utf-16"?> <color_swatch image="navy_cardigan.jpg">Navy</color_swatch>
30	color_swatch	2	5	image	1	Attribute	catalog/product/catalog_item/size/color_swatch/@image	catalog[1]/product[1]/catalog_item[2]/size[1]/color_swatch[2]/@image	\|-@image	navy_cardigan.jpg	null
31	size	1	5	color_swatch	3	Element	catalog/product/catalog_item/size/color_swatch	catalog[1]/product[1]/catalog_item[2]/size[1]/color_swatch[3]	\|-color_swatch	Burgundy	<?xml version="1.0" encoding="utf-16"?> <color_swatch image="burgundy_cardigan.jpg">Burgundy</color_swatch>
32	color_swatch	3	5	image	1	Attribute	catalog/product/catalog_item/size/color_swatch/@image	catalog[1]/product[1]/catalog_item[2]/size[1]/color_swatch[3]/@image	\|-@image	burgundy_cardigan.jpg	null
33	catalog_item	2	4	size	2	Element	catalog/product/catalog_item/size	catalog[1]/product[1]/catalog_item[2]/size[2]	\|-size	null	<?xml version="1.0" encoding="utf-16"?> <size description="Medium"> <color_swatch image="red_cardigan.jpg">Red</color_swatch> <color_swatch image="navy_cardigan.jpg">Navy</color_swatch> <color_swatch image="burgundy_cardigan.jpg">Burgundy</color_swatch> <color_swatch image="black_cardigan.jpg">Black</color_swatch> </size>
34	size	2	4	description	1	Attribute	catalog/product/catalog_item/size/@description	catalog[1]/product[1]/catalog_item[2]/size[2]/@description	\|-@description	Medium	null
35	size	2	5	color_swatch	1	Element	catalog/product/catalog_item/size/color_swatch	catalog[1]/product[1]/catalog_item[2]/size[2]/color_swatch[1]	\|-color_swatch	Red	<?xml version="1.0" encoding="utf-16"?> <color_swatch image="red_cardigan.jpg">Red</color_swatch>
36	color_swatch	1	5	image	1	Attribute	catalog/product/catalog_item/size/color_swatch/@image	catalog[1]/product[1]/catalog_item[2]/size[2]/color_swatch[1]/@image	\|-@image	red_cardigan.jpg	null
37	size	2	5	color_swatch	2	Element	catalog/product/catalog_item/size/color_swatch	catalog[1]/product[1]/catalog_item[2]/size[2]/color_swatch[2]	\|-color_swatch	Navy	<?xml version="1.0" encoding="utf-16"?> <color_swatch image="navy_cardigan.jpg">Navy</color_swatch>
38	color_swatch	2	5	image	1	Attribute	catalog/product/catalog_item/size/color_swatch/@image	catalog[1]/product[1]/catalog_item[2]/size[2]/color_swatch[2]/@image	\|-@image	navy_cardigan.jpg	null
39	size	2	5	color_swatch	3	Element	catalog/product/catalog_item/size/color_swatch	catalog[1]/product[1]/catalog_item[2]/size[2]/color_swatch[3]	\|-color_swatch	Burgundy	<?xml version="1.0" encoding="utf-16"?> <color_swatch image="burgundy_cardigan.jpg">Burgundy</color_swatch>
40	color_swatch	3	5	image	1	Attribute	catalog/product/catalog_item/size/color_swatch/@image	catalog[1]/product[1]/catalog_item[2]/size[2]/color_swatch[3]/@image	\|-@image	burgundy_cardigan.jpg	null
41	size	2	5	color_swatch	4	Element	catalog/product/catalog_item/size/color_swatch	catalog[1]/product[1]/catalog_item[2]/size[2]/color_swatch[4]	\|-color_swatch	Black	<?xml version="1.0" encoding="utf-16"?> <color_swatch image="black_cardigan.jpg">Black</color_swatch>
42	color_swatch	4	5	image	1	Attribute	catalog/product/catalog_item/size/color_swatch/@image	catalog[1]/product[1]/catalog_item[2]/size[2]/color_swatch[4]/@image	\|-@image	black_cardigan.jpg	null
43	catalog_item	2	4	size	3	Element	catalog/product/catalog_item/size	catalog[1]/product[1]/catalog_item[2]/size[3]	\|-size	null	<?xml version="1.0" encoding="utf-16"?> <size description="Large"> <color_swatch image="navy_cardigan.jpg">Navy</color_swatch> <color_swatch image="black_cardigan.jpg">Black</color_swatch> </size>
44	size	3	4	description	1	Attribute	catalog/product/catalog_item/size/@description	catalog[1]/product[1]/catalog_item[2]/size[3]/@description	\|-@description	Large	null
45	size	3	5	color_swatch	1	Element	catalog/product/catalog_item/size/color_swatch	catalog[1]/product[1]/catalog_item[2]/size[3]/color_swatch[1]	\|-color_swatch	Navy	<?xml version="1.0" encoding="utf-16"?> <color_swatch image="navy_cardigan.jpg">Navy</color_swatch>
46	color_swatch	1	5	image	1	Attribute	catalog/product/catalog_item/size/color_swatch/@image	catalog[1]/product[1]/catalog_item[2]/size[3]/color_swatch[1]/@image	\|-@image	navy_cardigan.jpg	null
47	size	3	5	color_swatch	2	Element	catalog/product/catalog_item/size/color_swatch	catalog[1]/product[1]/catalog_item[2]/size[3]/color_swatch[2]	\|-color_swatch	Black	<?xml version="1.0" encoding="utf-16"?> <color_swatch image="black_cardigan.jpg">Black</color_swatch>
48	color_swatch	2	5	image	1	Attribute	catalog/product/catalog_item/size/color_swatch/@image	catalog[1]/product[1]/catalog_item[2]/size[3]/color_swatch[2]/@image	\|-@image	black_cardigan.jpg	null
49	catalog_item	2	4	size	4	Element	catalog/product/catalog_item/size	catalog[1]/product[1]/catalog_item[2]/size[4]	\|-size	null	<?xml version="1.0" encoding="utf-16"?> <size description="Extra Large"> <color_swatch image="burgundy_cardigan.jpg">Burgundy</color_swatch> <color_swatch image="black_cardigan.jpg">Black</color_swatch> </size>
50	size	4	4	description	1	Attribute	catalog/product/catalog_item/size/@description	catalog[1]/product[1]/catalog_item[2]/size[4]/@description	\|-@description	Extra Large	null
51	size	4	5	color_swatch	1	Element	catalog/product/catalog_item/size/color_swatch	catalog[1]/product[1]/catalog_item[2]/size[4]/color_swatch[1]	\|-color_swatch	Burgundy	<?xml version="1.0" encoding="utf-16"?> <color_swatch image="burgundy_cardigan.jpg">Burgundy</color_swatch>
52	color_swatch	1	5	image	1	Attribute	catalog/product/catalog_item/size/color_swatch/@image	catalog[1]/product[1]/catalog_item[2]/size[4]/color_swatch[1]/@image	\|-@image	burgundy_cardigan.jpg	null
53	size	4	5	color_swatch	2	Element	catalog/product/catalog_item/size/color_swatch	catalog[1]/product[1]/catalog_item[2]/size[4]/color_swatch[2]	\|-color_swatch	Black	<?xml version="1.0" encoding="utf-16"?> <color_swatch image="black_cardigan.jpg">Black</color_swatch>
54	color_swatch	2	5	image	1	Attribute	catalog/product/catalog_item/size/color_swatch/@image	catalog[1]/product[1]/catalog_item[2]/size[4]/color_swatch[2]/@image	\|-@image	black_cardigan.jpg	null