USP_DATALIST_SPONSORSHIPOPPORTUNITYAVAILABLECOUNT
Returns the count of available opportunities by program and location.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SPONSORSHIPPROGRAMID | uniqueidentifier | IN | |
| @SPONSORSHIPLOCATIONID | uniqueidentifier | IN | |
| @EXCLUDESPONSORSHIPLOCATIONID | uniqueidentifier | IN |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_SPONSORSHIPOPPORTUNITYAVAILABLECOUNT(
@SPONSORSHIPPROGRAMID uniqueidentifier = null,
@SPONSORSHIPLOCATIONID uniqueidentifier = null,
@EXCLUDESPONSORSHIPLOCATIONID uniqueidentifier = null
)
as
set nocount on;
select dbo.UFN_SPONSORSHIPOPPORTUNITY_AVAILABLECOUNT(
@SPONSORSHIPPROGRAMID,
@SPONSORSHIPLOCATIONID,
@EXCLUDESPONSORSHIPLOCATIONID)