UFN_OPPORTUNITYAMOUNTBRACKET_GETBRACKETS

Returns a table of brackets for a corresponding opportunity amount ranges group.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@OPPORTUNITYBRACKETGROUPID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_OPPORTUNITYAMOUNTBRACKET_GETBRACKETS(@OPPORTUNITYBRACKETGROUPID uniqueidentifier)
returns table
as return
            select
                ID,
        NAME, 
                LOWERLIMIT
      from 
          dbo.OPPORTUNITYAMOUNTBRACKET
            where
                OPPORTUNITYBRACKETGROUPID = @OPPORTUNITYBRACKETGROUPID;