USP_DATALIST_RELATIONSHIPSFORSPECIFICCONSTITUENT

CREATE procedure dbo.USP_DATALIST_RELATIONSHIPSFORSPECIFICCONSTITUENT
(
    @RECIPROCALCONSTITUENTID uniqueidentifier
)
as
    set nocount on;

    select 
        r.ID as RELATIONSHIPID,
        r.RELATIONSHIPCONSTITUENTID as RELATIONSHIPCONSTITUENTID,
        rt.DESCRIPTION as RELATIONSHIPDESCRIPTION
    from dbo.RELATIONSHIP r
    inner join dbo.RELATIONSHIPTYPECODE rt
        on r.RELATIONSHIPTYPECODEID = rt.ID
    where RECIPROCALCONSTITUENTID = @RECIPROCALCONSTITUENTID