Stackoverflow - Sql server recursive self join, Sql Server

Stackoverflow - Sql server recursive self join

Language: Layout:

View schema
Execution time: 0,02 sec, rows selected: 10, rows affected: 10, absolute service time: 0,14 sec

edit mode | history

  
id
name
path

1
1
A
A

2
5
B
B

3
6
B.1
B,B.1

4
8
B.2
B,B.2

5
7
B.1.1
B,B.1,B.1.1

6
2
A.1
A,A.1

7
3
A.2
A,A.2

8
4
A.1.1
A,A.1,A.1.1

9
9
A.1.1.1
A,A.1,A.1.1,A.1.1.1

10
10
A.1.1.2
A,A.1,A.1.1,A.1.1.2

λ

                                      .NET NoSQL database for rapid development