UFN_HOUSEHOLD_GETMEMBERRECOGNIZEOTHERMEMBERSSETTING

            CREATE function dbo.UFN_HOUSEHOLD_GETMEMBERRECOGNIZEOTHERMEMBERSSETTING
            (
                @HOUSEHOLDID uniqueidentifier
            )
            returns tinyint
            as
            begin
                declare @MEMBERRECOGNIZEOTHERMEMBERSCODE tinyint

                select
                    @MEMBERRECOGNIZEOTHERMEMBERSCODE = MEMBERRECOGNIZEOTHERMEMBERSCODE
                from dbo.HOUSEHOLDRECOGNITIONSETTINGS where ID = @HOUSEHOLDID

                if @MEMBERRECOGNIZEOTHERMEMBERSCODE is null 
                    select top 1
                        @MEMBERRECOGNIZEOTHERMEMBERSCODE = MEMBERRECOGNIZEOTHERMEMBERS
                    from dbo.HOUSEHOLDINFO
                    order by DATEADDED

                set @MEMBERRECOGNIZEOTHERMEMBERSCODE = coalesce(@MEMBERRECOGNIZEOTHERMEMBERSCODE, 0)

                return @MEMBERRECOGNIZEOTHERMEMBERSCODE
            end