USP_SIMPLEDATALIST_DESIGNATIONLEVEL_STEWARDSHIPRECIPIENTS

Returns all fundraising purpose recipients for the given purpose.

Parameters

Parameter Parameter Type Mode Description
@DESIGNATIONLEVELID uniqueidentifier IN Purpose

Definition

Copy


            CREATE procedure dbo.USP_SIMPLEDATALIST_DESIGNATIONLEVEL_STEWARDSHIPRECIPIENTS(@DESIGNATIONLEVELID uniqueidentifier = null
            as
                begin

                select distinct D.CONSTITUENTID as VALUE, D.CONSTITUENTNAME as LABEL 
                from dbo.UFN_DESIGNATIONLEVEL_GETDONORS(@DESIGNATIONLEVELID, null, null, null) D 

                end