USP_DATALIST_REVENUEMERGEDATA_RECOGNITION

CREATE procedure dbo.USP_DATALIST_REVENUEMERGEDATA_RECOGNITION
(
        @EVENTID uniqueidentifier,
      @REVENUEID uniqueidentifier
)
  as
      set nocount on;

select TOP 1
  RecipientConstituentName = case 
    when TFT.NAME IS not NULL and Len(TFT.NAME)>0 then TFT.NAME
    when RGN.ID IS NOT NULL then dbo.UFN_REGISTRANT_GETNAME(RGN.ID) 
    else dbo.UFN_EVENT_GETNAME(@EVENTID) end 
  ,ISNULL(D.VANITYNAME, '') AS DESIGNATIONNAME
from REVENUE R
left outer join dbo.REVENUESPLIT RS on R.ID = RS.REVENUEID
LEFT OUTER JOIN dbo.DESIGNATION D ON D.ID = RS.DESIGNATIONID AND RS.TYPECODE = 0
left outer join dbo.REVENUERECOGNITION RC on RC.REVENUESPLITID=RS.ID
left OUTER JOIN dbo.TEAMEXTENSION TET ON TET.TEAMCONSTITUENTID=RC.CONSTITUENTID and TET.EVENTID= @EVENTID
left OUTER JOIN dbo.REGISTRANT RGN ON RGN.CONSTITUENTID = RC.CONSTITUENTID and RGN.EVENTID= @EVENTID
left outer join dbo.TEAMFUNDRAISINGTEAM TFT on TFT.ID=TET.TEAMFUNDRAISINGTEAMID
where 
  R.ID = @REVENUEID
    ORDER BY D.NAME DESC