Simplest way to do a recursive self-join?

Simplest way to do a recursive self-join?

sql sql-server recursion hierarchical-data self-join

sql-server

How do I create a recursive query in MSSQL 2005?

sql sql-server database recursion

sql-server

SQL: How to create view from a recursive query?

sql sql-server sql-server-2008 recursion view

sql-server

Is recursion good in SQL Server?

sql-server recursion

sql-server

Creating permutation via recursive CTE in SQL server?

sql-server recursion sql-server-2008-r2 common-table-expression

sql-server