USP_SIMPLEDATALIST_ACADEMICCATALOGCOLLEGE_2

CREATE procedure dbo.USP_SIMPLEDATALIST_ACADEMICCATALOGCOLLEGE_2
(
    @ACADEMICCATALOGPROGRAMID uniqueidentifier = null
)
as
    set nocount on;

    select
        COLLEGE.ID as VALUE,
        COLLEGE.NAME + ' - ' + DEGREE.NAME as LABEL
    from
        dbo.ACADEMICCATALOGCOLLEGE COLLEGE
    inner join 
        dbo.ACADEMICCATALOGDEGREE as DEGREE on COLLEGE.ACADEMICCATALOGDEGREEID = DEGREE.ID
    where
        DEGREE.ACADEMICCATALOGPROGRAMID = @ACADEMICCATALOGPROGRAMID
    order by
        LABEL;