Introduction to HierarchyId data type - Amazing feature of SQL Server

With earlier version before 2008 of the SQL server, When we need to required hierarchical data at that time we were using the loop to get the data of parent - child hierarchy. And it was make code lengthy , very complex and costly as well. What should...