USP_USERSETTINGS_USERHOMEPAGE_CREATEORUPDATE

CREATE procedure dbo.USP_USERSETTINGS_USERHOMEPAGE_CREATEORUPDATE
    @APPUSERID uniqueidentifier,
    @USERHOMEPAGE xml,
    @CHANGEAGENTID uniqueidentifier = null
as

set nocount on

declare @existingID uniqueidentifier
select @existingID = ID from dbo.USERSETTINGS where APPUSERID = @APPUSERID

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

declare @date datetime
set @date = getdate()

if @existingID is null 

    begin
        declare @ID uniqueidentifier
        set @ID = NewID()

        insert into dbo.USERSETTINGS 
            (ID, APPUSERID, USERHOMEPAGE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
        values 
            (@ID, @APPUSERID, @USERHOMEPAGE, @CHANGEAGENTID, @CHANGEAGENTID, @date, @date)
    end

else

    update dbo.USERSETTINGS 
    set USERHOMEPAGE = @USERHOMEPAGE,
        CHANGEDBYID = @CHANGEAGENTID,
        DATECHANGED = @date
    where ID = @existingID

RETURN 0;