USP_SIMPLEDATALIST_ACADEMICCATALOGCOLLEGEQUERY

Returns a list of academic catalog colleges for query.

Definition

Copy 


                CREATE procedure dbo.USP_SIMPLEDATALIST_ACADEMICCATALOGCOLLEGEQUERY
                as
                    set nocount on;

                    select distinct
                        ACADEMICCATALOGCOLLEGE.NAME as VALUE,
                        ACADEMICCATALOGCOLLEGE.NAME as LABEL
                    from
                        dbo.ACADEMICCATALOGCOLLEGE
                    order by ACADEMICCATALOGCOLLEGE.NAME;