Recursive Directory Listing in Transact-SQL
Demonstrates how to use recursive common table expressions (CTEs) in SQL Server to display a directory listing, given a self-referencing database table. The example script concatenates folder names to form the complete path to each folder. Continue reading