USP_DATALIST_REVENUEMERGEDATA_RECEIPT

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

 select 
    RR.RECEIPTNUMBER
  ,case when RR.ID is null then '' else CS.VALUE+'Components/EReceipt.ashx?rid='+lower(convert(varchar(50),R.ID)) end RECEIPTLINK
from dbo.REVENUE R
inner join dbo.EVENT EV on R.APPEALID = EV.APPEALID 
left join dbo.EVENTEXTENSION EE ON EE.EVENTID=EV.ID
left join dbo.CMSSITESETTING CS ON CS.CLIENTSITESID=EE.CLIENTSITESID AND CS.SETTING='AppPathURL'
left join dbo.REVENUERECEIPT RR ON RR.REVENUEID=R.ID 
where R.ID = @REVENUEID