UFN_STEWARDSHIPPLANSTEP_GETNAME

CREATE function dbo.UFN_STEWARDSHIPPLANSTEP_GETNAME
(
    @ID uniqueidentifier
)
returns nvarchar(100)
with execute as caller
as begin
    declare @NAME nvarchar(150);

    select
    @NAME = NF_CONSTITUENT.NAME + ' - ' + STEWARDSHIPPLAN.NAME
    from
      dbo.STEWARDSHIPPLANSTEP
  inner join dbo.STEWARDSHIPPLAN
    on STEWARDSHIPPLAN.ID = STEWARDSHIPPLANSTEP.PLANID
  outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(STEWARDSHIPPLAN.CONSTITUENTID) NF_CONSTITUENT
    where
        STEWARDSHIPPLANSTEP.ID = @ID;

    if @NAME is null
        return '';

    return @NAME;
end