UFN_CONSTITUENTUPDATEBATCH_MAPFROM_SPOUSEATTRIBUTE

        create function dbo.UFN_CONSTITUENTUPDATEBATCH_MAPFROM_SPOUSEATTRIBUTE(@ID uniqueidentifier) 
        returns uniqueidentifier
        as
        begin

            DECLARE @SPOUSEID uniqueidentifier;

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

            RETURN @SPOUSEID;

        end