Thanks dj, your suggestion helped me out. I did solve it:

CREATE PROC dbo.ShowHierarchyXML2

(

@Root int,

@MaxLevels int

--@SortOrderNumIn int = 0

)

AS

BEGIN

SET NOCOUNT ON

DECLARE @ChildNodeID int,@SortOrderNum int,@curNodeLabel varchar(30), @curChildNodeID int, @curParentNodeID int, @curPriorParent...

Yeah I am currently using the FOR XML method and using recursion in the XSL to properly format it...but I need to exhaust this possibility for the sake of determining...