USP_EDITSAVE_NETCOMMUNITYINTEGRATION

            CREATE procedure dbo.USP_EDITSAVE_NETCOMMUNITYINTEGRATION
            (
                @CHANGEAGENTID uniqueidentifier = null,
                @URL nvarchar(1024)
            )
            as
                set nocount on;

                declare @CURRENTDATE datetime;

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

                set @CURRENTDATE = getdate();

                begin try
                    if not exists (select ID from dbo.NETCOMMUNITYINTEGRATION where ID = '8E7E8AA7-8443-4680-B413-54EC605DFDAD')
                        insert into dbo.NETCOMMUNITYINTEGRATION
                        (
                            ID,
                            URL,

                            ADDEDBYID,
                            CHANGEDBYID,
                            DATEADDED,
                            DATECHANGED
                        )
                        values
                        (
                            '8E7E8AA7-8443-4680-B413-54EC605DFDAD',
                            @URL,

                            @CHANGEAGENTID,
                            @CHANGEAGENTID,
                            @CURRENTDATE,
                            @CURRENTDATE
                        );
                    else
                        update 
                            dbo.[NETCOMMUNITYINTEGRATION]
                        set
                            [URL] = @URL,

                            [DATECHANGED] = @CURRENTDATE,
                            [CHANGEDBYID] = @CHANGEAGENTID
                        where 
                            [NETCOMMUNITYINTEGRATION].ID = '8E7E8AA7-8443-4680-B413-54EC605DFDAD';
                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR;
                    return 1;
                end catch

                return 0;