IF exists (select 'x' from dbo.sysobjects where id = object_id(N'[dbo].[showNode]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 BEGIN
  drop procedure [dbo].[showNode]
 END
 GO
 
CREATE PROCEDURE [dbo].[showNode]
AS
BEGIN
 SELECT
    Node.nSeq,
--    CONCAT(REPEAT("\t", (COUNT(Parent.nSeq) - 1) ), Node.strName) as strName, --먼지몰라서 주석처리함
    Node.nLeft,
    Node.nRight
   FROM NestedSetMenu  Node,
    NestedSetMenu  Parent
  WHERE Node.nLeft BETWEEN Parent.nLeft AND Parent.nRight
  GROUP BY Node.nSeq
  ORDER By Node.nLeft
END