SQL Server 2005: Recursive Query (aka Common Table Expression)

SQL recursion for cascading results from the same table.
-- UP THE TREE
DECLARE @Id INT
SET @Id = 1

BEGIN
WITH myTree (Id, ParentId, Field)
AS (
-- anchor member declaration
SELECT Id, ParentId, Field FROM myTable WHERE ParentId = @Id
UNION ALL
-- recursive member declaration
SELECT myTable.Id, myTable.ParentId, myTable.Field FROM myTable INNER JOIN myTree ON myTree.Id = myTable.ParentId
)
SELECT DISTINCT * FROM myTable INNER JOIN myTree ON myTree.Id = myTable.Id
END


-- DOWN THE TREE
BEGIN
WITH myTree (Id, ParentId, Field)
AS (
-- anchor member declaration
SELECT Id, ParentId, Field FROM myTable WHERE Id = @Id
UNION ALL
-- recursive member declarationjavascript:void(0)
SELECT myTable.Id, myTable.ParentId, myTable.Field FROM myTable
INNER JOIN myTree ON myTree.ParentId = myTable.OrgId
)
SELECT DISTINCT * FROM myTable INNER JOIN myTree ON myTree.Id = myTable.Id
END


I can't believe they call recursive queries "common table expressions." Who does that make sense to?