USP_SIMPLEDATALIST_STEWARDSHIPPLANSTEWARDS

CREATE procedure dbo.USP_SIMPLEDATALIST_STEWARDSHIPPLANSTEWARDS
(
    @STEWARDSHIPPLANID uniqueidentifier = null
)
as begin
    set nocount on;

    select
        STEWARDSHIPPLANSTEWARD.CONSTITUENTID as VALUE,
        NF.NAME as LABEL
    from
        dbo.STEWARDSHIPPLANSTEWARD
    inner join dbo.CONSTITUENT
        on STEWARDSHIPPLANSTEWARD.CONSTITUENTID = CONSTITUENT.ID
    outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(CONSTITUENT.ID) NF
    where 
        STEWARDSHIPPLANSTEWARD.PLANID = @STEWARDSHIPPLANID
    order by
            CONSTITUENT.KEYNAME, 
            CONSTITUENT.FIRSTNAME
end