UFN_CONSTITUENT_EDUCATIONALHISTORYIMPLIESCONSTITUENCY

create function dbo.UFN_CONSTITUENT_EDUCATIONALHISTORYIMPLIESCONSTITUENCY
(
    @CONSTITUENTID uniqueidentifier,
    @CONSTITUENCYIMPLIEDCODE tinyint
)
returns table
as return
(
    select top 1
        1 as CONSTITUENCYISIMPLIED
    from dbo.[EDUCATIONALHISTORY] EH WITH (NOLOCK)
    inner join dbo.[EDUCATIONALINSTITUTION] EI WITH (NOLOCK) on [EH].[EDUCATIONALINSTITUTIONID] = [EI].[ID]
        AND [EI].[ISAFFILIATED] = 1
    inner join dbo.[EDUCATIONALHISTORYSTATUS] EHS on [EH].[EDUCATIONALHISTORYSTATUSID] = [EHS].[ID]
        where [EH].[CONSTITUENTID] = @CONSTITUENTID
        and [EHS].[CONSTITUENCYIMPLIEDCODE] = @CONSTITUENCYIMPLIEDCODE
)