declare	@node_table_name varchar(255)
declare @TreeID uniqueidentifier

set @node_table_name = 'ntm_tasks'
set @TreeID = NewID()

exec ntm_create_node_table

exec ntm_test_insert_node @TreeID=@TreeID, @buddy_name=null, @node_name='Music', @insert_type='AS_SIBLING'
exec ntm_test_insert_node @TreeID=@TreeID, @buddy_name='music', @node_name='blues', @insert_type='AS_CHILD'
exec ntm_test_insert_node @TreeID=@TreeID, @buddy_name='music', @node_name='alternative', @insert_type='AS_SIBLING'
exec ntm_test_insert_node @TreeID=@TreeID, @buddy_name='alternative', @node_name='punk', @insert_type='AS_CHILD'

exec ntm_test_deactivate_node @TreeID=@TreeID, @node_name='alternative'
exec ntm_test_activate_node @TreeID=@TreeID, @node_name='alternative'

--exec ntm_test_insert_node @TreeID=@TreeID, 'alternative', 'blues', 'AS_CHILD'

--exec ntm_test_delete_node @TreeID=@TreeID, @node_name='alternative'

--exec ntm_test_indent_node @TreeID=@TreeID, @node_name='alternative'
--exec ntm_test_indent_node @TreeID=@TreeID, @node_name='alternative'
--exec ntm_test_indent_node @TreeID=@TreeID, @node_name='punk
--exec ntm_test_outdent_node @TreeID=@TreeID, @node_name='punk'
--exec ntm_test_outdent_node @TreeID=@TreeID, @node_name='punk'

--exec ntm_test_move_node @TreeID=@TreeID, @move_node_name='alternative', @buddy_node_name='blues', @move_type='AS_SIBLING'
--exec ntm_test_move_node @TreeID=@TreeID, @move_node_name='alternative', @buddy_node_name='blues', @move_type='AS_CHILD'


SELECT 
	space(COUNT(Child.nleft)) + child.NodeName
	,COUNT(Child.nleft) AS lvl
	,Child.nleft
	,Child.nright
	,Child.NodeID
	,Child.InternalNodeID
	,Child.ParentID
FROM  
	ntm_nodes Parent CROSS JOIN ntm_nodes Child
WHERE 
	Child.nleft BETWEEN Parent.nleft AND Parent.nright
	and child.TreeID = @TreeID
	and child.ntmActive = 1
GROUP BY 
	Child.nleft
	,Child.nright
	,Child.NodeName
	,Child.NodeID
	,Child.InternalNodeID
	,Child.ParentID
order by
	child.nleft