• How to Query Hierarchical data Using CTE in T-SQL 2005? with sample codes....Try this!!!!!!!!!!!

    http://www.windowsitlibrary.com/Content/2052/03/1.html