UFN_CONSTITUENT_GETSPOUSESUFFIX2_TVF

Retrieve Spouse Suffix 2 for a given constituent

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_CONSTITUENT_GETSPOUSESUFFIX2_TVF(@CONSTITUENTID uniqueidentifier)
returns table
as 
return
(
    select
        SUFFIXCODE.DESCRIPTION as VALUE
    from dbo.RELATIONSHIP RP with(nolock)
        inner join dbo.CONSTITUENT SPOUSE with(nolock)on RP.RECIPROCALCONSTITUENTID = SPOUSE.ID
        inner join dbo.SUFFIXCODE with(nolock) on SPOUSE.SUFFIX2CODEID = SUFFIXCODE.ID
    where
        RP.RELATIONSHIPCONSTITUENTID = @CONSTITUENTID
            and RP.ISSPOUSE = 1
)