USP_RESEARCHGROUP_INCREMENTNUMMEMBERS

Increment a research group number of members

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@VALUE	int	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



            create procedure dbo.USP_RESEARCHGROUP_INCREMENTNUMMEMBERS (
                @ID uniqueidentifier = null,
                @VALUE int = 0,
                @CHANGEAGENTID uniqueidentifier = null
            ) as
                set nocount on;

                declare @CURRENTDATE datetime;
                set @CURRENTDATE = getdate();

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

                update
                    dbo.RESEARCHGROUP
                set 
                    NUMMEMBERS = case when NUMMEMBERS + @VALUE > 0 then NUMMEMBERS + @VALUE else 0 end,
                    CHANGEDBYID = @CHANGEAGENTID,
                    DATECHANGED = @CURRENTDATE
                where
                    ID = @ID