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