UFN_CONSTITUENTBATCH_MAPFROM_BUSINESSATTRIBUTE

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

            DECLARE @BUSINESSID uniqueidentifier;

            SELECT @BUSINESSID=RELATIONSHIP.RECIPROCALCONSTITUENTID from dbo.CONSTITUENT 
      inner join dbo.RELATIONSHIP on CONSTITUENT.ID = RELATIONSHIP.RELATIONSHIPCONSTITUENTID and ISPRIMARYBUSINESS = 1
      where CONSTITUENT.ID=@ID;

            RETURN @BUSINESSID;

        end