UFN_CONSTITID_FROM_CONSTITUENTRECOGNITIONID

Maps a CONSTITUENTRECOGNITIONID to a CONSTITUENTID.

Return

Return Type
uniqueidentifier

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTRECOGNITIONID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_CONSTITID_FROM_CONSTITUENTRECOGNITIONID
            (
                @CONSTITUENTRECOGNITIONID uniqueidentifier
            )
            returns uniqueidentifier
            as
            begin
                declare @ID uniqueidentifier

                select
                    @ID = CONSTITUENTID
                from dbo.CONSTITUENTRECOGNITION
                where ID = @CONSTITUENTRECOGNITIONID

                return @ID
            end