Using Recursive Common Table Expressions to Generate a Hierarchy in T-SQL

Optimizing Database Design: Multiple Tables vs One Table with More Columns