USP_SIMPLEDATALIST_ACADEMICCATALOGDEPARTMENT_BYSCHOOL

Returns a list of departments for a school.

Parameters

Parameter	Parameter Type	Mode	Description
@SCHOOLID	uniqueidentifier	IN	School

Definition

Copy



create procedure dbo.USP_SIMPLEDATALIST_ACADEMICCATALOGDEPARTMENT_BYSCHOOL(@SCHOOLID uniqueidentifier)
as

    select 
        ID as VALUE, 
        USERID as LABEL
    from 
        dbo.ACADEMICCATALOGDEPARTMENT
    where 
        ACADEMICCATALOGDEPARTMENT.SCHOOLID = @SCHOOLID
    order by 
        USERID