USP_SIMPLEDATALIST_ACADEMICCATALOGSUBDEPARTMENTQUERY

Returns a list of academic catalog sub departments for query.

Definition

Copy


create procedure dbo.USP_SIMPLEDATALIST_ACADEMICCATALOGSUBDEPARTMENTQUERY
as
    set nocount on;

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