UFN_CONSTITUENTID_MAPFROM_STEPID

Maps a STEPID (INTERACTIONID) to a CONSTITUENTID.

Return

Return Type
uniqueidentifier

Parameters

Parameter	Parameter Type	Mode	Description
@STEPID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_CONSTITUENTID_MAPFROM_STEPID(@STEPID uniqueidentifier)
returns uniqueidentifier
as 
begin
    declare @ID uniqueidentifier;

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

    return @ID;
end