UFN_REVENUE_GETORDEREDDESIGNATIONS

            CREATE function dbo.UFN_REVENUE_GETORDEREDDESIGNATIONS
            (
                @REVENUEID uniqueidentifier
            )
            returns table
            as
            return 
                select 
                    row_number() over (order by SPLIT.AMOUNT 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 as AMOUNT
                from
                    dbo.REVENUESPLIT SPLIT
                inner join
                    dbo.DESIGNATION on SPLIT.DESIGNATIONID = DESIGNATION.ID
                where
                    SPLIT.REVENUEID = @REVENUEID