UFN_CONSTITUENTID_MAPFROM_CONSTITUENTCORRESPONDENCEID

Maps a CONSTITUENTCORRESPONDENCEID to a CONSTITUENTID

Return

Return Type
uniqueidentifier

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTCORRESPONDENCEID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_CONSTITUENTID_MAPFROM_CONSTITUENTCORRESPONDENCEID(@CONSTITUENTCORRESPONDENCEID uniqueidentifier) 
            returns uniqueidentifier
            as
            begin
                declare @ID uniqueidentifier;

                select @ID = CONSTITUENTCORRESPONDENCE.CONSTITUENTID from dbo.CONSTITUENTCORRESPONDENCE
where CONSTITUENTCORRESPONDENCE.ID = @CONSTITUENTCORRESPONDENCEID
;

                RETURN @ID;
            end