USP_SEARCHLISTREPLACEMENT_DELETE

CREATE procedure dbo.USP_SEARCHLISTREPLACEMENT_DELETE
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null
)
as begin

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

    declare @noSettings bit;
    select @noSettings = 1 from dbo.SearchListSettings where ID = @ID and SETTINGSXML is NULL;

    -- use the system generated delete routine to allow proper recording of the deleting agent

    if @noSettings = 1
        exec USP_SEARCHLISTSETTINGS_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID;
    else
        update dbo.SEARCHLISTSETTINGS set REPLACEMENTSEARCHLISTID = null, CHANGEDBYID = @CHANGEAGENTID, DATECHANGED = getdate() where ID = @ID;

    return 0;

end