UFN_CONSTITID_MAPFROM_GROUPGOALID

Maps an GroupGoalID to a ConstituentID

Return

Return Type
uniqueidentifier

Parameters

Parameter	Parameter Type	Mode	Description
@GROUPGOALID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_CONSTITID_MAPFROM_GROUPGOALID
(
    @GROUPGOALID uniqueidentifier
)
returns uniqueidentifier
as
    begin
        declare @ID uniqueidentifier;

        select
            @ID = GROUPGOAL.GROUPID
        from
            dbo.GROUPGOAL
        where
            GROUPGOAL.ID = @GROUPGOALID;

        return @ID;
    end