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