USP_FEEDALERT_UPDATEDATELASTPROCESSED

Updates the date last processed value for a user's given feed alert.

Parameters

Parameter	Parameter Type	Mode
@APPUSERFEEDALERTINSTANCEID	uniqueidentifier	IN
@DATELASTPROCESSED	datetime	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



            create procedure dbo.USP_FEEDALERT_UPDATEDATELASTPROCESSED
            (
                @APPUSERFEEDALERTINSTANCEID uniqueidentifier,
                @DATELASTPROCESSED datetime,
                @CHANGEAGENTID uniqueidentifier
            )
            as
            set nocount on;

            begin try
                update dbo.APPUSERFEEDALERTINSTANCE
                    set DATELASTPROCESSED = @DATELASTPROCESSED,
                        CHANGEDBYID = @CHANGEAGENTID,
                        DATECHANGED = getdate()
                where ID = @APPUSERFEEDALERTINSTANCEID;

            end try
            begin catch
                exec dbo.USP_RAISE_ERROR;
                return 1; 
            end catch

            return 0;