UFN_STUDENTSKILLCATEGORYCODE_HASSKILLS

Returns true if the Skill Category Code entry is used for any student skills. Can be null for uncategorized skills.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@STUDENTSKILLCATEGORYCODEID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_STUDENTSKILLCATEGORYCODE_HASSKILLS(
    @STUDENTSKILLCATEGORYCODEID uniqueidentifier
)
returns bit
with execute as caller
as begin

    return (
        select 
            case when 0 = (select count(ID) 
                            from dbo.STUDENTSKILL 
                            where 
                                (STUDENTSKILLCATEGORYCODEID = @STUDENTSKILLCATEGORYCODEID) 
                                or (@STUDENTSKILLCATEGORYCODEID is null and STUDENTSKILLCATEGORYCODEID is null))
                then 0
                else -1
            end
    )

end