UFN_CONSTITUENT_GETRELATIONSHIPS_FORUPDATEBATCH

create function dbo.UFN_CONSTITUENT_GETRELATIONSHIPS_FORUPDATEBATCH
(
    @CONSTITUENTID uniqueidentifier
)
returns table
as return

    select
        RELATIONSHIP.RECIPROCALCONSTITUENTID,
        RELATIONSHIP.RELATIONSHIPTYPECODEID,
        RELATIONSHIP.RECIPROCALTYPECODEID,
        RELATIONSHIP.STARTDATE
    from
        dbo.RELATIONSHIP
    where
        RELATIONSHIP.RELATIONSHIPCONSTITUENTID = @CONSTITUENTID;