USP_USERSETTINGSSEARCHLIST_CREATEORUPDATE_GRIDSETTINGS

create procedure dbo.USP_USERSETTINGSSEARCHLIST_CREATEORUPDATE_GRIDSETTINGS(@APPUSERID uniqueidentifier,
    @SEARCHLISTCATALOGID uniqueidentifier,
    @GRIDSETTINGS xml)
as
begin

    declare @EXISTINGID uniqueidentifier;

    select @EXISTINGID = ID from dbo.USERSETTINGSSEARCHLIST where APPUSERID = @APPUSERID and SEARCHLISTCATALOGID = @SEARCHLISTCATALOGID;

    if @EXISTINGID is null
    begin

        insert into dbo.USERSETTINGSSEARCHLIST (
            APPUSERID,
            SEARCHLISTCATALOGID,
            GRIDSETTINGS)
        values (
            @APPUSERID,
            @SEARCHLISTCATALOGID,
            @GRIDSETTINGS);

    end
    else
    begin

        update dbo.USERSETTINGSSEARCHLIST 
        set GRIDSETTINGS = @GRIDSETTINGS
        where ID = @EXISTINGID;

    end;

end;