UFN_CONSTITID_MAPFROM_MATCHINGGIFTCONDITIONID

Maps a MatchingGiftConditionID to a ConstituentID

Return

Return Type
uniqueidentifier

Parameters

Parameter Parameter Type Mode Description
@MATCHINGGIFTCONDITIONID uniqueidentifier IN

Definition

Copy


            create function dbo.UFN_CONSTITID_MAPFROM_MATCHINGGIFTCONDITIONID(@MATCHINGGIFTCONDITIONID uniqueidentifier)
            returns uniqueidentifier
            as begin
                declare @ID uniqueidentifier;

                select
                    @ID = [ORGANIZATIONID]
                from
                    dbo.[MATCHINGGIFTCONDITION]
                where
                    [ID] = @MATCHINGGIFTCONDITIONID;

                return @ID;
            end