USP_DATAFORMTEMPLATE_EDIT_PERSONALNOTESSETTINGS

        create procedure dbo.USP_DATAFORMTEMPLATE_EDIT_PERSONALNOTESSETTINGS (
            @ID uniqueidentifier,
            @CHANGEAGENTID uniqueidentifier = null,
            @SITECONTENTID int,
            @ONSUBMITPAGEID int,
            @NOTETYPECODEIDS xml
        )
        as
                    set nocount on;

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

                    declare @CURRENTDATE datetime
                    set @CURRENTDATE = getdate()

                    select @ID = [Guid] --Making sure we're using the right ID
                    from dbo.[SiteContent] with (nolock)
                    where ID = @SITECONTENTID

                    begin try                    
                        merge dbo.[PERSONALNOTESSETTINGS] as [TARGET]
                        using (select @ID as ID) as [SOURCE]
                        on (TARGET.ID = SOURCE.ID)
                        when matched then
                          update 
                            set 
                                SITECONTENTID = @SITECONTENTID,
                                ONSUBMITPAGEID = @ONSUBMITPAGEID,
                                NOTETYPECODEIDS = @NOTETYPECODEIDS,
                                CHANGEDBYID = @CHANGEAGENTID,
                                DATECHANGED = @CURRENTDATE
                        when not matched then
                            insert (
                                ID, 
                                SITECONTENTID, 
                                ONSUBMITPAGEID, 
                                NOTETYPECODEIDS,
                                ADDEDBYID, 
                                CHANGEDBYID, 
                                DATEADDED, 
                                DATECHANGED
                            ) 
                            values (
                                @ID, 
                                @SITECONTENTID, 
                                @ONSUBMITPAGEID,
                                @NOTETYPECODEIDS,
                                @CHANGEAGENTID, 
                                @CHANGEAGENTID, 
                                @CURRENTDATE, 
                                @CURRENTDATE
                            );
                    end try
                    begin catch
                        exec dbo.USP_RAISE_ERROR
                        return 1
                    end catch

                    return 0;