USP_ADVOCACYLOG_UPDATE

Update Advocacy Log table

Parameters

Parameter	Parameter Type	Mode
@ADVOCACYLOGID	int	IN
@STATUSCODE	tinyint	IN
@SERVERDATEUPDATED	datetime	IN

Definition

Copy



        create procedure dbo.USP_ADVOCACYLOG_UPDATE
        (
            @ADVOCACYLOGID int,
            @STATUSCODE tinyint = null,
            @SERVERDATEUPDATED datetime = null
        )
        as
            set nocount on;

        begin try
            UPDATE dbo.ADVOCACYLOG
            SET STATUSCODE = ISNULL(@STATUSCODE,STATUSCODE),
                SERVERDATEUPDATED = ISNULL(@SERVERDATEUPDATED,getdate())
            WHERE ADVOCACYLOGID = @ADVOCACYLOGID
        end try
            begin catch
                exec dbo.USP_RAISE_ERROR
                return 1
            end catch

        return 0;