USP_SIMPLEDATALIST_ACADEMICCATALOGDEPARTMENTQUERY

Returns a list of academic catalog departments for query.

Definition

Copy 


                CREATE procedure dbo.USP_SIMPLEDATALIST_ACADEMICCATALOGDEPARTMENTQUERY
                as
                    set nocount on;

                    select distinct
                        ACADEMICCATALOGDEPARTMENT.NAME as VALUE,
                        ACADEMICCATALOGDEPARTMENT.NAME as LABEL
                    from
                        dbo.ACADEMICCATALOGDEPARTMENT;