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