UFN_INSTALLATIONINFO_GETHOUSEHOLDSCANBEDONORS

Checks if households are allowed to be donors.

Return

Return Type
bit

Definition

Copy


            CREATE function dbo.UFN_INSTALLATIONINFO_GETHOUSEHOLDSCANBEDONORS()
            returns bit
            with execute as caller
            as begin
                declare @HOUSEHOLDSCANBEDONORS bit;

                select top 1
                    @HOUSEHOLDSCANBEDONORS = HOUSEHOLDSCANBEDONORS
                from dbo.HOUSEHOLDINFO
                order by DATEADDED

                return coalesce(@HOUSEHOLDSCANBEDONORS, 1);  -- Default to true

            end