USP_RECORDOPERATION_WEALTHUPDATES_RESEARCHGROUP_ENABLE

Executes the "WealthPoint Updates Research Group: Enable" record operation.

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN Input parameter indicating the ID of the record being deleted.
@CHANGEAGENTID uniqueidentifier IN Input parameter indicating the ID of the change agent invoking the delete.

Definition

Copy


                    CREATE procedure dbo.USP_RECORDOPERATION_WEALTHUPDATES_RESEARCHGROUP_ENABLE (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier = null
                    ) as begin

                        delete 
                            dbo.DISABLEDWEALTHUPDATES
                        where 
                            ID IN ( select CONSTITUENTID from RESEARCHGROUPMEMBER where RESEARCHGROUPID = @ID )

                        return 0
                    end