UFN_GROUPCANHAVEGOALS

Returns 1 when group is a committee

Return

Return Type
bit

Parameters

Parameter Parameter Type Mode Description
@GROUPID uniqueidentifier IN

Definition

Copy


CREATE function dbo.UFN_GROUPCANHAVEGOALS(@GROUPID uniqueidentifier)
returns bit
with execute as caller
as begin
    declare @canHaveGoals bit = 0
    set @canHaveGoals = dbo.UFN_CONSTITUENT_ISCOMMITTEE(@GROUPID); 
    return @canHaveGoals
end