UFN_CONFIGURATIONDATA_SITE

                CREATE function dbo.UFN_CONFIGURATIONDATA_SITE
                ()
                returns @QUERIES table
                    (
            ID uniqueidentifier NOT NULL,
            NAME nvarchar(250) NULL,
            DESCRIPTION nvarchar(max) NOT NULL,
            PARENTNAME nvarchar(250) NULL
                    )
                as                 
                begin
                    insert into @QUERIES (ID, NAME, DESCRIPTION, PARENTNAME) 
            SELECT ID,
                   NAME, 
                   DESCRIPTION, 
                   (select NAME from dbo.SITE where SITE.HIERARCHYPATH = S.HIERARCHYPATH.GetAncestor(1)) as PARENTNAME                  
            FROM dbo.SITE S
            ORDER BY HIERARCHYPATH  asc

                    return 
                end