UFN_HOUSEHOLD_GETHOUSEHOLDRECOGNIZEMEMBERSSETTING

create function dbo.UFN_HOUSEHOLD_GETHOUSEHOLDRECOGNIZEMEMBERSSETTING
(
    @HOUSEHOLDID uniqueidentifier
)
returns tinyint
as
begin
    declare @HOUSEHOLDRECOGNIZEMEMBERSCODE tinyint

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

    if @HOUSEHOLDRECOGNIZEMEMBERSCODE is null 
        select top 1
            @HOUSEHOLDRECOGNIZEMEMBERSCODE = HOUSEHOLDRECOGNIZEMEMBERS
        from dbo.HOUSEHOLDINFO
        order by DATEADDED

    set @HOUSEHOLDRECOGNIZEMEMBERSCODE = coalesce(@HOUSEHOLDRECOGNIZEMEMBERSCODE, 0)

    return @HOUSEHOLDRECOGNIZEMEMBERSCODE
end