UFN_CONSTITUENT_GETSPOUSEMAIDENNAME_TVF

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