UFN_OPPORTUNITYAMOUNTBRACKETSITE_GETSITES

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

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@OPPORTUNITYAMOUNTBRACKETGROUPID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_OPPORTUNITYAMOUNTBRACKETSITE_GETSITES(@OPPORTUNITYAMOUNTBRACKETGROUPID uniqueidentifier)
returns table
as return
            select
                ID,
        SITEID
            from
                dbo.OPPORTUNITYAMOUNTBRACKETSITES
            where
                OPPORTUNITYAMOUNTBRACKETGROUPID = @OPPORTUNITYAMOUNTBRACKETGROUPID;