UFN_ESTIMATEDWEALTH_GETFORMATTEDRANGES

            create function dbo.UFN_ESTIMATEDWEALTH_GETFORMATTEDRANGES()
            returns @ESTIMATEDWEALTHRANGES_FORMATTED table(ID uniqueidentifier, RANGE nvarchar(100))
            with execute as caller

            as
            begin
                with    
                    ESTIMATEDWEALTH_MIN as (
                        select
                            ESTIMATEDWEALTH.[ID] ID,
                            ESTIMATEDWEALTH.[MINIMUMAMOUNT] MINAMOUNT,
                            ROW_NUMBER() over (order by ESTIMATEDWEALTH.[MINIMUMAMOUNT]) ROWNUMBER
                        from
                            dbo.[ESTIMATEDWEALTH]
                    ),

                    ESTIMATEDWEALTH_MIN_MAX as (
                        select    
                            ESTIMATEDWEALTH_MIN.[ID],        
                                ESTIMATEDWEALTH_MIN.[MINAMOUNT],
                                (    select
                                        convert(money,[MINAMOUNT] - 1.00)
                                     from
                                         ESTIMATEDWEALTH_MIN SUB
                                    where 
                                        SUB.[ROWNUMBER] = ESTIMATEDWEALTH_MIN.[ROWNUMBER] + 1
                                ) MAXAMOUNT

                            from
                                ESTIMATEDWEALTH_MIN
                    )

                insert into @ESTIMATEDWEALTHRANGES_FORMATTED    
                select 
                    ID,
                    case 
                        when MAXAMOUNT IS NULL then
                         '$'+convert(nvarchar(50),MINAMOUNT,1) + ' and up'
                        else  
                         '$'+convert(nvarchar(50),MINAMOUNT,1) + ' - $'+ convert(nvarchar(50),MAXAMOUNT,1) 
                    end as [RANGE]
                from
                    ESTIMATEDWEALTH_MIN_MAX

                return;
            end