USP_SIMPLEDATALIST_ACADEMICCATALOGDEGREE
Returns a list of academic catalog degrees for a given program.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ACADEMICCATALOGPROGRAMID | uniqueidentifier | IN | Program |
Definition
Copy
CREATE procedure dbo.USP_SIMPLEDATALIST_ACADEMICCATALOGDEGREE
(
@ACADEMICCATALOGPROGRAMID uniqueidentifier = null
)
as
set nocount on;
select
ID as VALUE,
NAME as LABEL
from
dbo.ACADEMICCATALOGDEGREE
where
ACADEMICCATALOGPROGRAMID = @ACADEMICCATALOGPROGRAMID
or @ACADEMICCATALOGPROGRAMID is null
order by
NAME;