USP_DATALIST_RE7WEBINTEGRATIONRESEARCHGROUP_SYNC

                create procedure dbo.USP_DATALIST_RE7WEBINTEGRATIONRESEARCHGROUP_SYNC (
                    @ID uniqueidentifier
                ) as
                    set nocount on;

                    select
                        RESEARCHGROUPMEMBER.CONSTITUENTID,
                        RE7INTEGRATIONCONSTITUENTMAP.RE7RECORDID
                    from
                        dbo.RESEARCHGROUPMEMBER
                    inner join dbo.RE7INTEGRATIONCONSTITUENTMAP    on
                        RE7INTEGRATIONCONSTITUENTMAP.ID = RESEARCHGROUPMEMBER.CONSTITUENTID
                    where
                        RESEARCHGROUPMEMBER.RESEARCHGROUPID = @ID