UFN_DESIGNATIONQUALIFICATIONSTATUS
Returns the gift aid qualification status of a designation.
Return
| Return Type |
|---|
| nvarchar(25) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @DESIGNATIONID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_DESIGNATIONQUALIFICATIONSTATUS
(
@DESIGNATIONID uniqueidentifier
)
returns nvarchar(25)
with execute as caller
as begin
declare @FOUND bit;
set @FOUND = 0
select
@FOUND = 1
from
dbo.GIFTAIDDISQUALIFIEDBYDESIGNATION
where
ID = @DESIGNATIONID;
if @FOUND = 1
return 'Not qualified';
return 'Qualified';
end