UFN_CONSTITUENTBATCH_MAPFROM_EDUCATIONATTRIBUTE

Returns the education id given a constituent id.

Return

Return Type
uniqueidentifier

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



        CREATE function dbo.UFN_CONSTITUENTBATCH_MAPFROM_EDUCATIONATTRIBUTE(@ID uniqueidentifier) 
        returns uniqueidentifier
        as
        begin

            DECLARE @EDUCATIONID uniqueidentifier;

            SELECT @EDUCATIONID=EDUCATIONALHISTORY.ID from dbo.EDUCATIONALHISTORY 
      where EDUCATIONALHISTORY.CONSTITUENTID=@ID;

            RETURN @EDUCATIONID;

        end