USP_REPORTROOTFOLDERS_CREATEORUPDATE

      CREATE procedure [dbo].[USP_REPORTROOTFOLDERS_CREATEORUPDATE]
          @FOLDERPATH [nvarchar](1024),
          @DISPLAYNAME [nvarchar](255),
          @SEQUENCE [int],
          @CHANGEAGENTID [uniqueidentifier] = null
      with execute as caller
      as
      set NOCOUNT on;

      declare @ID uniqueidentifier

      if (@FOLDERPATH is null) or len(@FOLDERPATH)= 0
          raiserror('FolderPath is required',16,1)

      if @CHANGEAGENTID is null
          exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

      set @ID = null
      select @ID = ID from dbo.REPORTROOTFOLDERLIST where FOLDERPATH = @FOLDERPATH

      declare @CURRENTDATE datetime
      set @CURRENTDATE = getdate()

      if @ID is null
          insert into dbo.REPORTROOTFOLDERLIST(ID, FOLDERPATH, DISPLAYNAME, SEQUENCE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
          values (NEWID(), @FOLDERPATH, @DISPLAYNAME, @SEQUENCE, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)

      else
          update dbo.REPORTROOTFOLDERLIST set FOLDERPATH = @FOLDERPATH, 
            DISPLAYNAME = @DISPLAYNAME,
            SEQUENCE = @SEQUENCE,
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = @CURRENTDATE
          where ID = @ID