UFN_OPPORTUNITYAMOUNTRANGES

Returns opportunity amount brackets with a calculated upper limit.

Return

Return Type
table

Definition

Copy



            CREATE function dbo.UFN_OPPORTUNITYAMOUNTRANGES()
            returns table            
            as            
            return (
                select
                    L.ID,
                    L.NAME,
                    L.LOWERLIMIT,
                    coalesce(min(U.LOWERLIMIT)-0.01,922337203685477.58) UPPERLIMIT
                from
                    dbo.OPPORTUNITYAMOUNTBRACKET L
                    left outer join dbo.OPPORTUNITYAMOUNTBRACKET U on U.LOWERLIMIT>L.LOWERLIMIT
                group by 
                    L.ID,
                    L.NAME,
                    L.LOWERLIMIT
            )