UFN_REVENUE_GETORDEREDDESIGNATIONS_BYROWNUMBER

CREATE function dbo.[UFN_REVENUE_GETORDEREDDESIGNATIONS_BYROWNUMBER]
(
  @REVENUEID uniqueidentifier,
  @ROWNUMBER int
)
returns table
as
return 
  select
    T.DESIGNATIONID,
    T.DESIGNATIONNAME,
    T.DESIGNATIONPUBLICNAME,
    T.TRANSACTIONAMOUNT,
    T.AMOUNT,
    T.ORGANIZATIONAMOUNT
  from (
    select 
      row_number() over (order by SPLIT.TRANSACTIONAMOUNT desc) as ROWNUMBER,
      DESIGNATION.ID as DESIGNATIONID,
      DESIGNATION.NAME as DESIGNATIONNAME,
      case len(DESIGNATION.VANITYNAME)
        when 0 then dbo.UFN_DESIGNATION_GETNODENAME(DESIGNATION.ID) 
        else DESIGNATION.VANITYNAME
      end as DESIGNATIONPUBLICNAME,
      SPLIT.TRANSACTIONAMOUNT,
      SPLIT.AMOUNT,
      SPLIT.ORGANIZATIONAMOUNT
    from dbo.REVENUESPLIT SPLIT
    inner join dbo.DESIGNATION on SPLIT.DESIGNATIONID = DESIGNATION.ID
    where SPLIT.REVENUEID = @REVENUEID
  ) as T
  where T.ROWNUMBER = @ROWNUMBER;