CTE – A T-SQL Solution to Recursive Queries

29Jun08

We often need to deal with hierarchies (tree structures) in SQL. Some common examples are employee hierarchies, parent-child hierarchies etc.   There is a clean solution to achieve it using CTE (Common Table Expressions) which is demonstrated below with a simple example.   The diagram below represents a parent-child hierarchy:      And the table [...]

Filed under: SQL Server, SQL Server 2005, T-SQL   |  Leave a Comment
Tags: Common Table Expressions, CTE, Recursive Query SQL, SQL Recursion