Export data from dynamic XML hierarchy in SQL Aerver

I want to get the lowest value in the hierarchy in a dynamic XML file.

Export data from dynamic xml hierarchy in sql server

I want to get the lowest value in the hierarchy in a dynamic XML file.