USP_DATALIST_SPONSORSHIPPROGRAMISAFFILIATEDATALIST
Returns affiliate information for a sponsorship program.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PROGRAMNAME | nvarchar(100) | IN | Program name |
Definition
Copy
create procedure dbo.USP_DATALIST_SPONSORSHIPPROGRAMISAFFILIATEDATALIST(@PROGRAMNAME nvarchar(100))
as
set nocount on;
select SP.ID,
case WHEN SAP.AFFILIATEID IS NULL then 0
else 1 end as ISAFFILIATE
from dbo.SPONSORSHIPPROGRAM SP
left outer join dbo.SPONSORSHIPAFFILIATEPROGRAM SAP on SAP.ID = SP.ID
where SP.NAME = @PROGRAMNAME