UFN_PROSPECTPLANID_MAPFROM_PLANNEDGIFTID

Maps a PLANNEDGIFTID to a PROSPECTPLANID

Return

Return Type
uniqueidentifier

Parameters

Parameter	Parameter Type	Mode	Description
@PLANNEDGIFTID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_PROSPECTPLANID_MAPFROM_PLANNEDGIFTID(@PLANNEDGIFTID uniqueidentifier) 
            returns uniqueidentifier
            as
            begin
                declare @ID uniqueidentifier;

                select
                    @ID = PLANNEDGIFT.PROSPECTPLANID
                from
                    dbo.PLANNEDGIFT
                where
                    PLANNEDGIFT.ID = @PLANNEDGIFTID;

                return @ID;
            end