UFN_CONSTITUENT_GETSPOUSEMAIDENNAME

Find the Spouse Maiden Name for a given constituent

Return

Return Type
nvarchar(100)

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_CONSTITUENT_GETSPOUSEMAIDENNAME(@CONSTITUENTID uniqueidentifier)
            returns nvarchar(100)
            as 
            begin
                declare @SPOUSEID uniqueidentifier;
                declare @MAIDENNAME nvarchar(100) = N'';

                select top 1 @SPOUSEID = RELATIONSHIP.RECIPROCALCONSTITUENTID 
                from dbo.RELATIONSHIP 
                where RELATIONSHIP.RELATIONSHIPCONSTITUENTID = @CONSTITUENTID and RELATIONSHIP.ISSPOUSE = 1

                select @MAIDENNAME = MAIDENNAME
                from dbo.CONSTITUENT
                where ID = @SPOUSEID;

                return @MAIDENNAME;
            end