UFN_SITEID_MAPFROM_OPPORTUNITYAMOUNTBRACKETGROUPID

Maps a OPPORTUNITYAMOUNTBRACKETGROUPID to a SITEID

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@OPPORTUNITYAMOUNTBRACKETGROUPID	uniqueidentifier	IN

Definition

Copy



           create function dbo.UFN_SITEID_MAPFROM_OPPORTUNITYAMOUNTBRACKETGROUPID  
           (  
            @OPPORTUNITYAMOUNTBRACKETGROUPID uniqueidentifier  
           )   
           returns table
           as  
            return
                (
                    select OPPORTUNITYAMOUNTBRACKETSITES.SITEID 
                    from 
                    (select @OPPORTUNITYAMOUNTBRACKETGROUPID as GROUPID) as T
                    left join dbo.OPPORTUNITYAMOUNTBRACKETSITES on OPPORTUNITYAMOUNTBRACKETSITES.OPPORTUNITYAMOUNTBRACKETGROUPID = T.GROUPID
                )