UFN_SITEID_MAPFROM_SECONDARYFUNDRAISERID

Maps an SECONDARYFUNDRAISERID to a SITEID

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@SECONDARYFUNDRAISERID	uniqueidentifier	IN

Definition

Copy



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