UFN_BATCHCONSTITUENTUPDATE_GETRELATIONSHIPS

CREATE function dbo.UFN_BATCHCONSTITUENTUPDATE_GETRELATIONSHIPS
(
    @BATCHCONSTITUENTUPDATEID uniqueidentifier
) returns table
as
return
(
    select
        BATCHCONSTITUENTUPDATERELATIONSHIPS.ID,
        BATCHCONSTITUENTUPDATERELATIONSHIPS.RECIPROCALCONSTITUENTID,
        BATCHCONSTITUENTUPDATERELATIONSHIPS.RELATIONSHIPTYPECODEID,
        BATCHCONSTITUENTUPDATERELATIONSHIPS.RECIPROCALTYPECODEID,
        BATCHCONSTITUENTUPDATERELATIONSHIPS.STARTDATE,
        BATCHCONSTITUENTUPDATERELATIONSHIPS.SEQUENCE,
        RECIPROCAL.LOOKUPID
    from
        dbo.BATCHCONSTITUENTUPDATERELATIONSHIPS 
        inner join dbo.CONSTITUENT RECIPROCAL on BATCHCONSTITUENTUPDATERELATIONSHIPS.RECIPROCALCONSTITUENTID = RECIPROCAL.ID
    where
        BATCHCONSTITUENTUPDATERELATIONSHIPS.BATCHCONSTITUENTUPDATEID = @BATCHCONSTITUENTUPDATEID
);