USP_GLOBALCHANGE_REFRESHSEARCHCONSTITUENT

Parameters

Parameter	Parameter Type	Mode
@CHANGEAGENTID	uniqueidentifier	IN
@ASOF	datetime	IN
@NUMBERADDED	int	INOUT
@NUMBEREDITED	int	INOUT
@NUMBERDELETED	int	INOUT

Definition

Copy



CREATE procedure dbo.USP_GLOBALCHANGE_REFRESHSEARCHCONSTITUENT
(
    @CHANGEAGENTID uniqueidentifier = null,
    @ASOF as datetime = null,
    @NUMBERADDED int = 0 output,
    @NUMBEREDITED int = 0 output,
    @NUMBERDELETED int = 0 output
)
as            
    set nocount off;

    set @NUMBERADDED = 0;
    set @NUMBEREDITED = 0;
    set @NUMBERDELETED = 0; 

    begin try
        exec dbo.USP_POPULATESEARCHCONSTITUENT @NUMBERADDED output
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR;
        return 1;
    end catch