USP_DATALIST_SPONSORSHIPPROGRAMINFO

Get program information for any given sponsorship program given the program id(guid) or the program name.

Parameters

Parameter	Parameter Type	Mode	Description
@CONTEXTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



CREATE procedure dbo.USP_DATALIST_SPONSORSHIPPROGRAMINFO(
    @CONTEXTID uniqueidentifier
)
as
    set nocount on;

    select
        SPONSORSHIPPROGRAM.SPONSORSHIPOPPORTUNITYGROUPID,
        SPONSORSHIPPROGRAM.AMOUNT,
        case when SPONSORSHIPAFFILIATEPROGRAM.ID is not null then 1 else 0 end ISAFFILIATE,
    SPONSORSHIPPROGRAM.BASECURRENCYID
    from dbo.SPONSORSHIPPROGRAM
    left outer join dbo.SPONSORSHIPAFFILIATEPROGRAM on SPONSORSHIPAFFILIATEPROGRAM.ID = SPONSORSHIPPROGRAM.ID
    where SPONSORSHIPPROGRAM.ID = @CONTEXTID