Read XMLColumn value and Get it in Table format

for Example the XML value is Like :


bbb
vvv
aaa


SELECT r1.value ('./@id', 'varchar(100)') as Attribute, '' as Value
FROM [Table Name] CROSS APPLY [ColumnName].nodes ('Root/D') AS x (r1)