UFN_SITEID_MAPFROM_PROSPECTPLANID

Maps a PROSPECTPLANID to multiple SITEID

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@PROSPECTPLANID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_SITEID_MAPFROM_PROSPECTPLANID(@PROSPECTPLANID uniqueidentifier)   
            returns table
            as  
            return
                select PROSPECTPLANSITE.SITEID   
                from dbo.PROSPECTPLAN
                left outer join dbo.PROSPECTPLANSITE on PROSPECTPLANSITE.PROSPECTPLANID = PROSPECTPLAN.ID
                where PROSPECTPLAN.ID = @PROSPECTPLANID;