With Fact (Num, Factorial)
As
(
	Select 0 as Num, convert(bigint, 1) as Factorial
	
	Union All
	
	Select Num + 1, convert(bigint, Num + 1) * Factorial from Fact
	Where Num + 1 <= 20 --Recursion Buster; not really necessary since Fact(21) doesn't fit in a BigInt anyway
)
Select * from Fact

;with HierarchyCTE (Lvl, ID, ParentID, Name) as
	(select 1, ID, ParentID, Name
	from dbo.Hierarchy
	union all
	select Lvl + 1, h2.ID, h2.ParentID, h2.Name
	from dbo.Hierarchy h2
	inner join HierarchyCTE
		on h2.ParentID = HierarchyCTE.ID)
select Lvl, ID, ParentID, Name
from HierarchyCTE
order by Name

;with FTreeCTE (Generation, ID, Parent1ID, Parent2ID, Name) as
	(select 1, ID, Parent1ID, Parent2ID, Name
	from dbo.FamilyTree
	union all
	select Generation + 1, ft2.ID, ft2.Parent1ID, ft2.Parent2ID, ft2.Name
	from dbo.FamilyTree ft2
	inner join FTreeCTE
		on ft2.Parent1ID = FTreeCTE.ID
		or ft2.Parent2ID = FTreeCTE.ID)
select Generation, ID, Parent1ID, Parent2ID, Name
from FTreeCTE
order by Generation