====== pears.TempVacancyShiftMatch2 ====== Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. ===== Original SQL ===== create function "pears"."TempVacancyShiftMatch2"( in @PersonID char(20),in @VacancyID char(20) ) returns char(50) begin -- Not passed to TempVacancyShiftMatchOrder needs to be looked up, if used declare "rv" char(50); set "rv" = null; return "rv" end