UFN_CONSTITID_CAMPAIGNFUNDRAISERID

Maps a CAMPAIGNFUNDRAISERID to a CONSTITUENTID.

Return

Return Type
uniqueidentifier

Parameters

Parameter	Parameter Type	Mode	Description
@CAMPAIGNFUNDRAISERID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_CONSTITID_CAMPAIGNFUNDRAISERID
            (
                @CAMPAIGNFUNDRAISERID uniqueidentifier
            )
            returns uniqueidentifier
            as
            begin
                declare @ID uniqueidentifier

                select
                    @ID = CONSTITUENTID
                from dbo.CAMPAIGNFUNDRAISER
                where ID = @CAMPAIGNFUNDRAISERID

                return @ID
            end