UFN_CONSTITID_MAPFROM_RELATIONSHIPID

Maps a user-defined ConstituencyID to a ConstituentID

Return

Return Type
uniqueidentifier

Parameters

Parameter Parameter Type Mode Description
@RELATIONSHIPID uniqueidentifier IN

Definition

Copy


create function dbo.UFN_CONSTITID_MAPFROM_RELATIONSHIPID(@RELATIONSHIPID uniqueidentifier) 
returns uniqueidentifier
as
begin

    DECLARE @ID uniqueidentifier;

    SELECT @ID=RELATIONSHIPCONSTITUENTID from dbo.RELATIONSHIP where ID=@RELATIONSHIPID;

    RETURN @ID;

end