UFN_SITEID_MAPFROM_PLANNEDGIFTID

Maps a PLANNEDGIFTID to a SITEID

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@PLANNEDGIFTID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_SITEID_MAPFROM_PLANNEDGIFTID  
            (  
            @PLANNEDGIFTID uniqueidentifier  
            )   
            returns table
            as  
            return
                select PLANNEDGIFTSITE.SITEID  
                from dbo.PLANNEDGIFT
                left outer join PLANNEDGIFTSITE on PLANNEDGIFTSITE.PLANNEDGIFTID = PLANNEDGIFT.ID
                where PLANNEDGIFT.ID = @PLANNEDGIFTID;