spGetDonationEReceiptByLinkKey

         CREATE procedure [dbo].[spGetDonationEReceiptByLinkKey](@LinkKey nvarchar(256)) as
                    select
                        der.EReceiptNumber,
                        der.PDF,
                        coalesce(dt.AddedByUserID, 0) AddedByUserID,
                        dt.DonationTransactionsID 
                    from dbo.DonationEReceipt der
                    inner join dbo.DonationTransactions dt on dt.DonationTransactionsID=der.DonationTransactionsID
                    where der.LinkKey = @LinkKey;