USP_SIMPLEDATALIST_ACADEMICCATALOGCOLLEGEFROMACADEMICDEGREE

List of Academic Catalog Colleges, Based on Academic Catalog Degree

Parameters

Parameter	Parameter Type	Mode	Description
@ACADEMICCATALOGDEGREEID	uniqueidentifier	IN	Degree

Definition

Copy



CREATE procedure dbo.USP_SIMPLEDATALIST_ACADEMICCATALOGCOLLEGEFROMACADEMICDEGREE
(
    @ACADEMICCATALOGDEGREEID uniqueidentifier = null
)
as
    set nocount on;

    select
        ID as VALUE,
        NAME as LABEL
    from
        dbo.ACADEMICCATALOGCOLLEGE
    where
        ACADEMICCATALOGDEGREEID = isnull(@ACADEMICCATALOGDEGREEID,ACADEMICCATALOGDEGREEID)