UFN_CONSTITID_MAPFROM_EVENTCOORDINATORID

Maps an EventCoordinatorID to a ConstituentID

Return

Return Type
uniqueidentifier

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTCOORDINATORID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_CONSTITID_MAPFROM_EVENTCOORDINATORID
(
    @EVENTCOORDINATORID uniqueidentifier
)
returns uniqueidentifier
as
    begin
        declare @ID uniqueidentifier;

        select
            @ID = EVENTCOORDINATOR.CONSTITUENTID
        from
            dbo.EVENTCOORDINATOR
        where
            EVENTCOORDINATOR.ID = @EVENTCOORDINATORID;

        return @ID;
    end