UFN_REVENUE_GETPREVIOUSUNIQUERECEIPTNUMBER

create function dbo.UFN_REVENUE_GETPREVIOUSUNIQUERECEIPTNUMBER
            (
                @REVENUEID uniqueidentifier
            )
            returns nvarchar(20)
            with execute as caller
            as
            begin
                declare @RECEIPTNUMBER nvarchar(20);

                select top 1 
                    @RECEIPTNUMBER = RR.UNIQUERECEIPTNUMBER 
                from 
                    dbo.REVENUERECEIPT RR 
                where 
                    RR.REVENUEID = @REVENUEID
                order by 
                    RR.RECEIPTPROCESSDATE desc;

                return @RECEIPTNUMBER; 
            end