UFN_REVENUE_GETTRIBUTEBYROWNUMBER

            create function dbo.UFN_REVENUE_GETTRIBUTEBYROWNUMBER
            (
                @REVENUEID uniqueidentifier,
                @ROWTORETURN int
            )
            returns table
            as
            return
                select
                    TYPE,
                    TRIBUTEE,
                    TRIBUTETEXT,
                    DEFAULTDESIGNATION,
                    AMOUNT
                from
                (
                    select 
                        row_number() over (order by TRIBUTE.TRIBUTETEXT) as ROWNUMBER,
                        TRIBUTETYPECODE.DESCRIPTION as TYPE,
                        CONSTITUENT.NAME as TRIBUTEE,
                        TRIBUTE.TRIBUTETEXT,
                        DESIGNATION.NAME as DEFAULTDESIGNATION,
                        REVENUETRIBUTE.AMOUNT
                    from dbo.REVENUETRIBUTE
                    inner join dbo.TRIBUTE on REVENUETRIBUTE.TRIBUTEID = TRIBUTE.ID
                    inner join dbo.TRIBUTETYPECODE on TRIBUTE.TRIBUTETYPECODEID = TRIBUTETYPECODE.ID
                    left join dbo.CONSTITUENT on TRIBUTE.TRIBUTEEID = CONSTITUENT.ID
                    left join dbo.DESIGNATION on TRIBUTE.DESIGNATIONID = DESIGNATION.ID
                    where REVENUETRIBUTE.REVENUEID = @REVENUEID
                ) as SUBQ
                where 
                    @ROWTORETURN = ROWNUMBER