====== pears.VacancyDetailsContents ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

===== Original SQL =====
<code sql>
create function "pears"."VacancyDetailsContents"( in @SMSOrEmail char(1),in @CandidateOrVacancy char(1),in @ProgressIDs long varchar ) 
returns long varchar
begin
  -- @SMSorEmail S or E, @CandidateOrVacancy C or V, @ProgressIDs ID1,ID2... for sa_split_list(@ProgressIDs) 
  -- sample for candidate
  --   select first name into rv from person key join progress join sa_split_list(@ProgressIDs) on progress.progressid = Row_value;
  -- sample for vacancy
  --   select first vacancyid into rv from progress join sa_split_list(@ProgressIDs) on progress.progressid = Row_value;
  declare "rv" long varchar;
  set "rv" = '';
  return "rv"
end
</code>