Currently browsing tag

hierarchy query in sql server