USP_USERSETTINGS_FAVORITES_CREATEORUPDATE

CREATE procedure [dbo].[USP_USERSETTINGS_FAVORITES_CREATEORUPDATE]
    @APPUSERID uniqueidentifier,
    @FAVORITES 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, FAVORITES, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
            values (@ID, @APPUSERID, @FAVORITES, @CHANGEAGENTID, @CHANGEAGENTID, @date, @date)
    end

else

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

RETURN 0;