USP_SIMPLELIST_CAMPAIGNFUNDRAISER
This simple list returns all of the campaigns a fundraiser is associated with.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @FUNDRAISERID | uniqueidentifier | IN | Fundraiser |
Definition
Copy
create procedure dbo.USP_SIMPLELIST_CAMPAIGNFUNDRAISER (
@FUNDRAISERID uniqueidentifier
) as begin
select
CAMPAIGN.ID [VALUE],
CAMPAIGN.NAME [LABEL]
from
dbo.CAMPAIGNFUNDRAISER
left outer join
dbo.CAMPAIGN on CAMPAIGNFUNDRAISER.CAMPAIGNID = CAMPAIGN.ID
where
CAMPAIGNFUNDRAISER.CONSTITUENTID = @FUNDRAISERID
end