UFN_CONSTITUENTID_MAPFROM_INTERACTIONID

Maps a INTERACTIONID to a CONSTITUENTID

Return

Return Type
uniqueidentifier

Parameters

Parameter	Parameter Type	Mode	Description
@INTERACTIONID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_CONSTITUENTID_MAPFROM_INTERACTIONID(@INTERACTIONID uniqueidentifier) 
            returns uniqueidentifier
            as
            begin
                declare @ID uniqueidentifier;

                select
                    @ID = INTERACTION.CONSTITUENTID
                from
                    dbo.INTERACTION
                where
                    INTERACTION.ID = @INTERACTIONID;

                return @ID;
            end