USP_DATALIST_TRIBUTEMERGEDATA

CREATE procedure dbo.USP_DATALIST_TRIBUTEMERGEDATA
  (
    @REVENUEID uniqueidentifier = null,
    @FROMCONSTITUENTID uniqueidentifier = null
  )
  as
      set nocount on;
select Tributee = case when TR.TRIBUTEEID is null then TRX.TRIBUTEEFIRSTNAME + ' ' + TRX.TRIBUTEELASTNAME else C.NAME end 
      , TributeeFirstName = TRX.TRIBUTEEFIRSTNAME 
      , TributeeLastName = TRX.TRIBUTEELASTNAME
      , TributeeEmailAddress = TRX.TRIBUTEEEMAILADDRESS 
      , TributeeAddress = TRX.TRIBUTEEADDRESSBLOCK
      , TributeeCity = TRX.TRIBUTEECITY 
      , TributeeState = TSTATE.DESCRIPTION 
      , TributeeZIP = TRX.TRIBUTEEPOSTCODE  
    , TributeType = TRC.DESCRIPTION 
    , TributeMessage = TR.TRIBUTETEXT 
    , AnonymousDonation = case isnull(R.GIVENANONYMOUSLY,0) when 1 then 'Yes' else 'No' end
    , IsSendEmailToAckNowledgee = case when isnull(trx.ACKNOWLEDGEEFIRSTNAME,'') <> '' OR isnull(trx.ACKNOWLEDGEELASTNAME,'') <> '' then 1 else 0 end
    , AcknowledgeeName = TRX.ACKNOWLEDGEEFIRSTNAME+' '+TRX.ACKNOWLEDGEELASTNAME
    , AcknowledgeeFisrtName = TRX.ACKNOWLEDGEEFIRSTNAME
    , AcknowledgeeLastName = TRX.ACKNOWLEDGEELASTNAME 
    , AcknowledgeeEmailAddress =TRX.ACKNOWLEDGEEEMAILADDRESS
    , ACKNOWLEDGEEMESSAGE =TRX.MESSAGETOACKNOWLEDGEE
    , ISDisplayTributeInfo = case when isnull(TRX.MESSAGETOACKNOWLEDGEE,'') = '' and isnull(TRX.ACKNOWLEDGEEFIRSTNAME,'') = '' and isnull(TRX.ACKNOWLEDGEELASTNAME,'') = '' and isnull(TRX.ACKNOWLEDGEEEMAILADDRESS,'') = '' then 0 else 1 end 
    , DefaultTributee = (CASE WHEN TRX.FROMCONSTITUENTID IS null then 0 else 1 end)
  from TRIBUTE TR 
  left join dbo.REVENUETRIBUTE RTR ON RTR.TRIBUTEID = TR.ID 
  left join dbo.REVENUE R on R.ID = RTR.REVENUEID  and (R.ID = @REVENUEID or @REVENUEID is null)
  left outer join TRIBUTEEXTENSION TRX on TRX.TRIBUTEID = TR.ID 
  left outer join CONSTITUENT C on C.ID = TR.TRIBUTEEID 
  left outer join TRIBUTETYPECODE TRC on TRC.ID = TR.TRIBUTETYPECODEID 
  left outer join  dbo.STATE TSTATE ON TRX.TRIBUTEESTATEID=TSTATE.ID 
where R.ConstituentID=@FROMCONSTITUENTID
or (trx.FROMCONSTITUENTID = @FROMCONSTITUENTID or @FROMCONSTITUENTID is null)