UFN_CONSTITUENT_GETSPOUSESUFFIX2

Retrieve Spouse Suffix 2 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_GETSPOUSESUFFIX2(@CONSTITUENTID uniqueidentifier)
returns nvarchar(100)
as 
begin
    declare @SPOUSEID uniqueidentifier;
    declare @SUFFIX2 nvarchar(100) = N'';

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

    select 
        @SUFFIX2 = SUFFIXCODE.DESCRIPTION
    from dbo.CONSTITUENT
    inner join dbo.SUFFIXCODE
        on CONSTITUENT.SUFFIX2CODEID = SUFFIXCODE.ID
    where CONSTITUENT.ID = @SPOUSEID;

    return @SUFFIX2;
end