Thank this author by sharing:
By Jacob Sebastian, 2011/07/11
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
Products ranked by category ranked
The XportXML utility, will help you copy relational data (a bunch of related tables) to another SQL ...
Hi everyone I want to know what would be best practice for the following scenario: Article ta...
Convert Horizontal Hierarchy to vertical Hierarchy.
One very common structure that needs to be handled in T-SQL is the hierarchy. One of our prominent m...
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.
Join us!
Steve Jones Editor, SQLServerCentral.com
