Subject Recursive Relationship on Dictionary Table


Is this list allowed to post SQL queries ou links? Anyway if someone is interested and can help me, I did a recent post on SO which has been a great challenge to me, although it seems simple at first sight:

Thanks in advance