TSQL Challenge 60 - Generate a relational tree structure from a string
An ETL application receives product and category information in a text file. The category hierarchy is specified as a string.
Your job is to read the hierarchy information and generate a relational table (result set) representing the hierarchy of categories.
http://beyondrelational.com/puzzles/tsql/60/english/generate-a-relational-tree-structure-from-a-string.aspx