UFN_REVENUE_GETMATCHINGGIFTBYROWNUMBER

            CREATE function dbo.UFN_REVENUE_GETMATCHINGGIFTBYROWNUMBER
            (
                @REVENUEID uniqueidentifier,
                @ROWTORETURN int
            )
            returns table
            as
            return
                select
                    ORGANIZATION,
                    CONDITIONTYPE,
                    AMOUNT,
                    TRANSACTIONCURRENCYID
                from
                (
                    select 
                        row_number() over (order by FINANCIALTRANSACTION.BASEAMOUNT desc) as ROWNUMBER,
                        CONSTITUENT.NAME as ORGANIZATION,
                        MATCHINGGIFTCONDITIONTYPECODE.DESCRIPTION as CONDITIONTYPE,
                        FINANCIALTRANSACTION.TRANSACTIONAMOUNT as AMOUNT,
                        FINANCIALTRANSACTION.TRANSACTIONCURRENCYID
                    from dbo.REVENUEMATCHINGGIFT
                    inner join dbo.FINANCIALTRANSACTION on REVENUEMATCHINGGIFT.ID = FINANCIALTRANSACTION.ID
                    inner join dbo.CONSTITUENT on FINANCIALTRANSACTION.CONSTITUENTID = CONSTITUENT.ID
                    left join dbo.MATCHINGGIFTCONDITION on REVENUEMATCHINGGIFT.MATCHINGGIFTCONDITIONID = MATCHINGGIFTCONDITION.ID
                    left join dbo.MATCHINGGIFTCONDITIONTYPECODE on MATCHINGGIFTCONDITION.MATCHINGGIFTCONDITIONTYPECODEID = MATCHINGGIFTCONDITIONTYPECODE.ID
                    where REVENUEMATCHINGGIFT.MGSOURCEREVENUEID = @REVENUEID
                ) as SUBQ
                where 
                    @ROWTORETURN = ROWNUMBER