UFN_COMMUNICATIONEXCLUSION_GETDESIGNATIONS

Returns the designations to be considered when calculating recent giving.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@COMMUNICATIONEXCLUSIONID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_COMMUNICATIONEXCLUSION_GETDESIGNATIONS
(
    @COMMUNICATIONEXCLUSIONID uniqueidentifier
)
returns table as
    return (
        select
            COMMUNICATIONEXCLUSIONDESIGNATIONS.ID,
            COMMUNICATIONEXCLUSIONDESIGNATIONS.DESIGNATIONID,
            DESIGNATION.NAME
        from dbo.COMMUNICATIONEXCLUSIONDESIGNATIONS
        inner join dbo.DESIGNATION
            on COMMUNICATIONEXCLUSIONDESIGNATIONS.DESIGNATIONID = DESIGNATION.ID
        where COMMUNICATIONEXCLUSIONID = @COMMUNICATIONEXCLUSIONID
    );