USP_WEALTHESTIMATORRATING_GETRANGES

            create procedure dbo.USP_WEALTHESTIMATORRATING_GETRANGES
            as
                set nocount on;

                with    
                    WEALTHESTIMATORRATING_MIN as (
                        select
                            WEALTHESTIMATORRATING.[ID] ID,
                            WEALTHESTIMATORRATING.[MINIMUMAMOUNT] MINAMOUNT,
                            ROW_NUMBER() over (order by WEALTHESTIMATORRATING.[MINIMUMAMOUNT]) ROWNUMBER
                        from
                            dbo.[WEALTHESTIMATORRATING]
                    ),

                    WEALTHESTIMATORRATING_MIN_MAX as (
                        select    
                            WEALTHESTIMATORRATING_MIN.[ID],        
                            WEALTHESTIMATORRATING_MIN.[MINAMOUNT],
                            (    select
                                    [MINAMOUNT] - 1.00
                                 from
                                     WEALTHESTIMATORRATING_MIN SUB
                                where 
                                    SUB.[ROWNUMBER] = WEALTHESTIMATORRATING_MIN.[ROWNUMBER] + 1
                            ) MAXAMOUNT

                        from
                            WEALTHESTIMATORRATING_MIN
                    )

                select
                    WEALTHESTIMATORRATING_MIN_MAX.[ID],
                    WEALTHESTIMATORRATING_MIN_MAX.[MINAMOUNT],
                    WEALTHESTIMATORRATING_MIN_MAX.[MAXAMOUNT]
                from
                    WEALTHESTIMATORRATING_MIN_MAX;