UFN_CONSTITUENT_GETSPOUSECLASSYEAR_TVF

CREATE function dbo.UFN_CONSTITUENT_GETSPOUSECLASSYEAR_TVF(@CONSTITUENTID uniqueidentifier)
returns table
as
return
(
    select
        cast(EH.CLASSOF as nvarchar(4)) as VALUE
    from dbo.RELATIONSHIP RP with(nolock)
        inner join dbo.EDUCATIONALHISTORY EH with(nolock) on RP.RECIPROCALCONSTITUENTID = EH.CONSTITUENTID
    where
        RP.RELATIONSHIPCONSTITUENTID = @CONSTITUENTID
            and RP.ISSPOUSE = 1
            and EH.ISPRIMARYRECORD = 1
            and EH.CLASSOF > 0
)