USP_DATALIST_SPONSORSHIPPROGRAMSFORGREATESTNEEDRULESET
Returns a list of sponsorship programs that use the specified greatest need rule set.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @RULESETID | uniqueidentifier | IN | Input parameter indicating the context ID for the data list. |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_SPONSORSHIPPROGRAMSFORGREATESTNEEDRULESET(@RULESETID uniqueidentifier)
as
set nocount on;
select ID
from dbo.SPONSORSHIPPROGRAM
where SPONSORSHIPGREATESTNEEDRULESETID = @RULESETID