i got my answer on MSDN. it involes build a full nodepath value using the siblingorder as such:

WITH Yak(NodeID, ParentNodeID, NodePath) AS (SELECT ...

The data from my first post was just sample data.

What you can see from the actual results is that all the level 1 records are coming back first...

WITH DirectReports(parentNode, childNode, LEVEL ) AS

(

SELECT e.parentTocNodeGuid, e.tocNodeGuid, 0 AS LEVEL

FROM TocNodes AS e

WHERE ...

I looked at the sample code in BOL and the query runs but is not returning the records in the sequence I want. It returns the first level 0...