Thank this author by sharing:
By Jacob Sebastian,
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.
Products ranked by category ranked
The XportXML utility, will help you copy relational data (a bunch of related tables) to another SQL ...
Recently a need resurfaced to explore the foreign key tree (hierarchy/genealogy) as it related to a ...
I want to know what would be best practice for the following scenario:
Convert Horizontal Hierarchy
to vertical Hierarchy.
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.