USP_SIMPLEDATALIST_STUDENTSKILLCATEGORY

Returns a list of skill category entries to support blank captions for uncategorized skills.

Definition



create procedure dbo.USP_SIMPLEDATALIST_STUDENTSKILLCATEGORY as

    declare @t table (ID uniqueidentifier, DESCRIPTION nvarchar(100), SEQUENCE int);

    insert into @t exec dbo.USP_STUDENTSKILLCATEGORYCODE_GETLIST @INCLUDEINACTIVE = 0;

    select 
        ID as VALUE, 
        DESCRIPTION as LABEL
    from @t