USP_DATALIST_PROGRAMGROUP

Lists all the program groups for a combination.

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

    select
        ID,
        NAME,
        DESCRIPTION
    from dbo.PROGRAMGROUP
    where COMBINATIONID = @CONTEXTID
    order by DATEADDED;