USP_DATALIST_REVENUEMERGEDATA_MATCHINGGIFT

CREATE procedure dbo.USP_DATALIST_REVENUEMERGEDATA_MATCHINGGIFT
(
      @REVENUEID uniqueidentifier
)
  as
      set nocount on;

select top 1
    MatchingGiftCompayName = case when RELATIONSHIP.ID is not null then ORG.NAME else null end 
    ,MatchingGiftAmount = MGR.AMOUNT

from REVENUE R
left join dbo.RELATIONSHIP on RELATIONSHIP.ISMATCHINGGIFTRELATIONSHIP =1 
                            and R.CONSTITUENTID = RELATIONSHIP.RELATIONSHIPCONSTITUENTID
                            and RELATIONSHIP.RELATIONSHIPTYPECODEID = (select PRIMARYBUSINESSRELATIONSHIPTYPECODEID from dbo.NETCOMMUNITYDEFAULTCODEMAP)
left join dbo.REVENUEMATCHINGGIFT RMG on RMG.MGSOURCEREVENUEID = R.ID and RMG.RELATIONSHIPID=RELATIONSHIP.ID 
left join dbo.MATCHINGGIFTCONDITION MGC on RMG.MATCHINGGIFTCONDITIONID = MGC.ID
left join dbo.REVENUE MGR on MGR.ID = RMG.ID 
left join dbo.CONSTITUENT ORG ON ORG.ID = RELATIONSHIP.RECIPROCALCONSTITUENTID
where R.ID = @REVENUEID