USP_SIMPLEDATALIST_SPONSORSHIPPROGRAMAFFILIATERESTRICT

Returns a list of sponsorship programs that are either affiliated or non-affiliated

Parameters

Parameter	Parameter Type	Mode	Description
@ISAFFILIATE	bit	IN	ISAFFILIATE

Definition

Copy



create procedure dbo.USP_SIMPLEDATALIST_SPONSORSHIPPROGRAMAFFILIATERESTRICT
(
    @ISAFFILIATE bit = 0
)as
    select 
        SPONSORSHIPPROGRAM.ID as VALUE, 
        SPONSORSHIPPROGRAM.NAME as LABEL
    from dbo.SPONSORSHIPPROGRAM
    left outer join dbo.SPONSORSHIPAFFILIATEPROGRAM on SPONSORSHIPAFFILIATEPROGRAM.ID = SPONSORSHIPPROGRAM.ID
    where (@ISAFFILIATE = 1 and SPONSORSHIPAFFILIATEPROGRAM.ID is not null) 
       or (@ISAFFILIATE = 0 and SPONSORSHIPAFFILIATEPROGRAM.ID is null)
    order by SPONSORSHIPPROGRAM.SEQUENCE, SPONSORSHIPPROGRAM.NAME