UFN_BATCHAUCTIONITEMCONSTITUENT_GETGROUPMEMBERS

            create function dbo.UFN_BATCHAUCTIONITEMCONSTITUENT_GETGROUPMEMBERS
            (
                @GROUPID uniqueidentifier
            )
            returns table
            as
            return
            (
                select
                    BRCGM.ID,
                    case when BRC.EXISTINGCONSTITUENTID is null then BRCGM.MEMBERID else BRC.EXISTINGCONSTITUENTID end MEMBERID,
                    BRCGM.ISPRIMARY,
                    case
                        when C.ID is not null then C.NAME
                        else BRC.NAME
                    end NAME
                from dbo.BATCHAUCTIONITEMCONSTITUENTGROUPMEMBER BRCGM
                inner join dbo.BATCHAUCTIONITEMCONSTITUENT BRC on BRCGM.MEMBERID = BRC.ID
                left join dbo.CONSTITUENT C on BRC.EXISTINGCONSTITUENTID = C.ID
                where
                    BRCGM.GROUPID = @GROUPID
            )