UFN_PROSPECTRESEARCHREQUEST_GETCONSTITUENTS

Returns all constituents in a given prospect research request.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@PROSPECTRESEARCHREQUESTID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_PROSPECTRESEARCHREQUEST_GETCONSTITUENTS(@PROSPECTRESEARCHREQUESTID uniqueidentifier)
returns table
as
return
(
    select
        ID,
        CONSTITUENTID
    from
        dbo.PROSPECTRESEARCHREQUESTCONSTITUENT
    where
        PROSPECTRESEARCHREQUESTID = @PROSPECTRESEARCHREQUESTID
);