UFN_BATCHSPONSORSHIPCONSTITUENT_GETGROUPMEMBERS

            CREATE function dbo.UFN_BATCHSPONSORSHIPCONSTITUENT_GETGROUPMEMBERS
            (
                @GROUPID uniqueidentifier
            )
            returns table
            as
                return
                (
                select
                BSCGM.ID,
                case when BSC.EXISTINGCONSTITUENTID is null then BSCGM.MEMBERID else BSC.EXISTINGCONSTITUENTID end MEMBERID,
                BSCGM.ISPRIMARY,
                case
                when BSC.EXISTINGCONSTITUENTID is not null then NF.NAME
                else BSC.NAME
                end NAME
                from dbo.BATCHSPONSORSHIPCONSTITUENTGROUPMEMBER BSCGM
                inner join dbo.BATCHSPONSORSHIPCONSTITUENT BSC on BSCGM.MEMBERID = BSC.ID
                outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(BSC.EXISTINGCONSTITUENTID) NF    
                where
                BSCGM.GROUPID = @GROUPID
                )