USP_SIMPLEDATALIST_ACADEMICCATALOGCOLLEGE

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

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