Just exclude the where clause in the last query to extract the parent items as well:

select

*

from

Tree

--where

--TreeLevel > 1

order by

ConcatName asc

This looks like hierarchical or "tree structured" data.

The following query can be used to extract hierarchical or "tree structured" data.

/** setup data **/

declare @table table (ID int, PID int,...

My bad. 🙁

Sorry - I did not see the follow-up article links earlier . . . were a bit a sleep - just shows how good the article is...

Thanks Gail. Brilliant article. Can't wait for part 2 and 3.