UFN_CONSTITUENT_ISPRIMARYHOUSEHOLDMEMBER

            create function dbo.UFN_CONSTITUENT_ISPRIMARYHOUSEHOLDMEMBER(@CONSTITUENTID uniqueidentifier)
            returns bit
            as
            begin
                declare @count int

                select @count = count(*)
                from GROUPMEMBER
                inner join GROUPDATA
                    on GROUPMEMBER.GROUPID = GROUPDATA.ID
                where GROUPMEMBER.MEMBERID = @CONSTITUENTID and GROUPDATA.GROUPTYPECODE = 0
                    and GROUPMEMBER.ISPRIMARY = 1;

                return case when @count > 0 then 1 else 0 end;
            end