UFN_REVENUERECEIPT_GETRERECEIPTREASONDETAILS

create function dbo.UFN_REVENUERECEIPT_GETRERECEIPTREASONDETAILS
            (
                @REVENUEID uniqueidentifier
            )
            returns nvarchar(300)
            with execute as caller
            as
            begin
                declare @REASONDETAILS nvarchar(300) = '';

                select top 1 
                    @REASONDETAILS = RD.DETAILS

                from 
                    dbo.REVENUERECEIPT RR 
                inner join dbo.REVENUERECEIPTRERECEIPTDETAIL RD on RD.REVENUERECEIPTID = RR.ID
                where 
                    RR.REVENUEID = @REVENUEID
                order by 
                    RR.RECEIPTPROCESSDATE desc;

                return @REASONDETAILS; 
end