Bert Wagner takes us through writing recursive statements in T-SQL:
Recursive queries are fun to plan and write. They can be frustrating too depending on the complexity of the problem you are trying to solve.
This post shows one solution for finding all records that are related, either directly or via intermediate records, using recursive queries in SQL Server.
When you know the data size will be fairly small and performance isn’t critical, recursion can be an elegant solution to a data access problem.