In case anyone is interested, Listed below is a bottom-up version of the proc:

CREATE PROCEDURE dbo.DisplayBottomUpTableHierarchy(

 @TableName VARCHAR(128),

 @SpaceLen INT = -4 OUTPUT)

AS

BEGIN

 DECLARE @child VARCHAR(100)

 SET @SpaceLen = @SpaceLen + 4

 IF @TableName IS NOT...