UFN_STEWARDSHIPPLAN_STEWARDS

CREATE function dbo.UFN_STEWARDSHIPPLAN_STEWARDS
(
    @PLANID uniqueidentifier
) 
returns table
as return
    select
        STEWARDSHIPPLANSTEWARD.ID, 
        STEWARDSHIPPLANSTEWARD.CONSTITUENTID, 
        STEWARDSHIPPLANSTEWARD.ROLECODEID, 
        NF.NAME, 
        STEWARDSHIPSTEWARDROLECODE.DESCRIPTION as PLANSTEWARDROLECODE,
        STEWARDSHIPPLANSTEWARD.STARTDATE,
        STEWARDSHIPPLANSTEWARD.ENDDATE
    from 
        dbo.STEWARDSHIPPLANSTEWARD
    left outer join dbo.STEWARDSHIPSTEWARDROLECODE 
        on STEWARDSHIPPLANSTEWARD.ROLECODEID = STEWARDSHIPSTEWARDROLECODE.ID
    cross apply dbo.UFN_CONSTITUENT_DISPLAYNAME(STEWARDSHIPPLANSTEWARD.CONSTITUENTID) NF

    where STEWARDSHIPPLANSTEWARD.PLANID = @PLANID