USP_REPORTROOTFOLDERS_GETLIST

      create procedure dbo.USP_REPORTROOTFOLDERS_GETLIST  
      with execute as caller
      as

        set NOCOUNT on;

        select [ID],[FOLDERPATH],[DISPLAYNAME],[SEQUENCE]
        from REPORTROOTFOLDERLIST
        order by [SEQUENCE];

      return 0