UFN_CONSTITUENT_HASSTEWARDSHIPPLAN

This functions returns true if the given constituent has a stewardship plan.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_CONSTITUENT_HASSTEWARDSHIPPLAN
(
    @CONSTITUENTID uniqueidentifier
)
returns bit
with execute as caller
as
begin
    if exists
        (
            select
                ID
            from
                dbo.STEWARDSHIPPLAN
            where
                CONSTITUENTID = @CONSTITUENTID
        )
        return 1;

    return 0;
end