USP_ESTIMATEDWEALTH_GETRANGE

Returns a estimated wealth range for a specific id.
Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@MINAMOUNT	money	INOUT
@MAXAMOUNT	money	INOUT
Definition

Copy


                create procedure dbo.USP_ESTIMATEDWEALTH_GETRANGE(
                    @ID        uniqueidentifier,
                    @MINAMOUNT money output,
                    @MAXAMOUNT money output
                )as
                    set nocount on;

                    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
                                        [MINAMOUNT] - 1.00
                                     from
                                         ESTIMATEDWEALTH_MIN SUB
                                    where 
                                        SUB.[ROWNUMBER] = ESTIMATEDWEALTH_MIN.[ROWNUMBER] + 1
                                ) MAXAMOUNT

                            from
                                ESTIMATEDWEALTH_MIN
                        )

                    select
                        @MINAMOUNT = ESTIMATEDWEALTH_MIN_MAX.[MINAMOUNT],
                        @MAXAMOUNT = ESTIMATEDWEALTH_MIN_MAX.[MAXAMOUNT]
                    from
                        ESTIMATEDWEALTH_MIN_MAX
                    where
                        ESTIMATEDWEALTH_MIN_MAX.[ID] = @ID;