USP_DATALIST_COMBINATIONPUBLICPROGRAMGROUPSINFO

CREATE procedure dbo.USP_DATALIST_COMBINATIONPUBLICPROGRAMGROUPSINFO
(
    @ID uniqueidentifier
)
as
    set nocount on;

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

    return 0;