Selecting path (multiple records) where an ID number (fk) in a table references , Sql Server

Selecting path (multiple records) where an ID number (fk) in a table r...

Language: Layout:

View schema
Execution time: 0,03 sec, rows selected: 15, rows affected: 15, absolute service time: 0,2 sec

fork mode | history

  
CategoryId
CategoryName
Path

1
1
Books
NULL

2
2
Music
NULL

3
3
Hardcover
[Books]

4
4
Softcover
[Books]

5
5
Electronic
[Books]

6
6
CD
[Music]

7
7
MP3
[Music]

8
8
Rock
[Music, CD]

9
9
Hard Rock
[Music, CD]

10
10
Classic Rock
[Music, CD]

11
11
Fiction
[Books, Hardcover]

12
12
Fiction
[Books, Softcover]

13
13
Non-Fiction
[Books, Hardcover]

14
14
Reference
[Books, Hardcover, Non-Fiction]

15
15
Biography
[Books, Hardcover, Non-Fiction]

λ

                                      .NET NoSQL database for rapid development