USP_SIMPLEDATALIST_ACADEMICCATALOGDIVISION

CREATE procedure dbo.USP_SIMPLEDATALIST_ACADEMICCATALOGDIVISION
(
    @ACADEMICCATALOGCOLLEGEID uniqueidentifier = null
)
as
    set nocount on;

    declare @CURRENTID uniqueidentifier;
    select
    @CURRENTID = CURRENTID
    from
    dbo.ACADEMICCATALOGCOLLEGE
    where
    ID = @ACADEMICCATALOGCOLLEGEID;

    select
    ID as VALUE,
    NAME as LABEL
    from
        dbo.ACADEMICCATALOGDIVISION
    where
        ACADEMICCATALOGCOLLEGEID = isnull(@ACADEMICCATALOGCOLLEGEID,ACADEMICCATALOGCOLLEGEID)
        or ACADEMICCATALOGCOLLEGEID = @CURRENTID;