USP_RESEARCHGROUP_RECALCULATENUMMEMBERS

Recalculates the number of members in a research group.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



            create procedure dbo.USP_RESEARCHGROUP_RECALCULATENUMMEMBERS (
                @ID uniqueidentifier = null,
                @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 = (select count(ID) from dbo.RESEARCHGROUPMEMBER where RESEARCHGROUPID = @ID),
                    CHANGEDBYID = @CHANGEAGENTID,
                    DATECHANGED = @CURRENTDATE
                where
                    ID = @ID