USP_RECORDOPERATION_MEMBERSHIPREMOVEAUTORENEWAL

create procedure dbo.USP_RECORDOPERATION_MEMBERSHIPREMOVEAUTORENEWAL
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier
)
as begin

    declare @CURRENTDATE datetime = getDate();

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

    update dbo.MEMBERSHIP set
        AUTOMATICALLYRENEWMEMBERSHIP = 0,
        CHANGEDBYID = @CHANGEAGENTID,
        DATECHANGED = @CURRENTDATE
    where ID = @ID;

    return 0;
end