UFN_CONSTITUENT_MAPFROM_GROUPMEMBER

Maps a group member to the constituent who owns it.

Return

Return Type
uniqueidentifier

Parameters

Parameter	Parameter Type	Mode	Description
@GROUPMEMBERID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_CONSTITUENT_MAPFROM_GROUPMEMBER
            (
                @GROUPMEMBERID uniqueidentifier
            )
            returns uniqueidentifier
            as
            begin
                declare @CONSTITUENTID uniqueidentifier;

                select top 1 
                    @CONSTITUENTID = MEMBERID
                from dbo.GROUPMEMBER
                where ID = @GROUPMEMBERID;

                return @CONSTITUENTID;
            end