How implementing an hierarchy without using a recursive CTE

Hi, I've noticed that the warehouse T-SQL doesn't support the recursive ctes and this is a pity! Now, how could I implement an hierarchy in T-SQL without a such useful and comfortable feature, plea...