Retrieve subtree part of current element hierarchy

SELECT Name FROM NuGreen.Asset.ElementHierarchy
WHERE Path LIKE N'\NuGreen\Houston\%'
AND Level <= 2 /*Level column can be used to restrict depth of hierarchy traversal*/