USP_TASKREMINDERALERT_UPDATEREMINDERSENT

Updates a task reminder to "Sent"

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@TABLENAME	nvarchar(100)	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



create procedure dbo.USP_TASKREMINDERALERT_UPDATEREMINDERSENT
(
    @ID uniqueidentifier
    , @TABLENAME nvarchar(100)
    , @CHANGEAGENTID uniqueidentifier
)
with execute as owner
as
begin
    set nocount on;

    if object_id(@TABLENAME) > 0 begin

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

        declare @SQLTOEXEC nvarchar(max) = N'update dbo.' + @TABLENAME + N' set SENT = 1, CHANGEDBYID = ''' + convert(nvarchar(36), @CHANGEAGENTID) + ''', DATECHANGED = getdate() where ID = ''' + convert(nvarchar(36), @ID) + '''';

        exec sp_executesql @SQLTOEXEC;
    end

    return 0;

end