USP_DATALIST_CMSRECEIPTKEYBYREVENUEID

CREATE procedure dbo.USP_DATALIST_CMSRECEIPTKEYBYREVENUEID
(
    @REVENUEID uniqueidentifier,
  @USERID integer = 0
)
as
    set nocount on;

 declare @sql as nvarchar(1000);
 set @sql = 'select DER.LinkKey as RECEIPTKEY from DonationEReceipt DER ';
 set @sql = @sql + 'inner join dbo.DonationTransactions dt on dt.DonationTransactionsID=der.DonationTransactionsID ';
 set @sql = @sql + 'inner join REVENUERECEIPT RR on RR.RECEIPTNUMBER = DER.Sequence ';
 set @sql = @sql + 'where RR.REVENUEID =''' +  convert(nvarchar(36),@REVENUEID) + ''' ';
 if @USERID > 0
 begin 
    set @sql = @sql + 'and dt.AddedByUserID =' + convert(varchar,@USERID) + ' ';
 end 

 set @sql = @sql + 'order by RECEIPTKEY;';

 EXEC sp_executesql @sql;