USP_DATALIST_SPONSORSHIPPROGRAMAGERANGEINFO

Gets the minimum and maximum age of a given sponsorship opportunity(child).

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_SPONSORSHIPPROGRAMAGERANGEINFO(@CONTEXTID uniqueidentifier)
as
    set nocount on;

    select ID,
           MINAGE,
           MAXAGE,
           DISPLAYNAME
    from dbo.SPONSORSHIPOPPORTUNITYAGERANGE
    where ID = @CONTEXTID