USP_SIMPLEDATALIST_SPONSORSHIPGREATESTNEEDRULESETFORGROUP
Simple list of sponsorship greatest need rule sets.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SPONSORSHIPOPPORTUNITYGROUPID | uniqueidentifier | IN | SPONSORSHIPOPPORTUNITYGROUPID |
Definition
Copy
CREATE procedure dbo.USP_SIMPLEDATALIST_SPONSORSHIPGREATESTNEEDRULESETFORGROUP (
@SPONSORSHIPOPPORTUNITYGROUPID uniqueidentifier
)
as
select
SPONSORSHIPGREATESTNEEDRULESET.ID as VALUE,
SPONSORSHIPGREATESTNEEDRULESET.NAME as LABEL
from dbo.SPONSORSHIPGREATESTNEEDRULESET
inner join dbo.SPONSORSHIPOPPORTUNITYGROUP on SPONSORSHIPOPPORTUNITYGROUP.ID = @SPONSORSHIPOPPORTUNITYGROUPID
where SPONSORSHIPGREATESTNEEDRULESET.SPONSORSHIPOPPORTUNITYTYPECODE = SPONSORSHIPOPPORTUNITYGROUP.SPONSORSHIPOPPORTUNITYTYPECODE
order by SPONSORSHIPGREATESTNEEDRULESET.NAME