USP_RECORDOPERATION_MICROSITEDEACTIVATEEVENTEMAILTEMPLATE

create procedure dbo.USP_RECORDOPERATION_MICROSITEDEACTIVATEEVENTEMAILTEMPLATE
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier
)
as begin
    set nocount on;

    declare @CURRENTDATE datetime = getDate();

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

    update dbo.EVENT_MICROSITEEMAILTEMPLATE set
        ACTIVE = 0,
        CHANGEDBYID = @CHANGEAGENTID,
        DATECHANGED = @CURRENTDATE
    where ID = @ID;

    return 0;    
end