select c.value('@Description', 'varchar(max)') as 'Description' , c.query('./nodeB') as Contentfrom @xml.nodes('/root/*') as T(c)-- Results to:Description Contentfirstgroup <nodeB mode="A" ability="read" />nextgroup <nodeB count="2" birthplace="Paris" />


