pears.VacancyKeyWordsQuestion

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

CREATE FUNCTION "pears"."VacancyKeyWordsQuestion"( 
  /* Application Maintained Function / Procedure - DO NOT EDIT*/
  IN @VacancyID CHAR(20) ) 
RETURNS long VARCHAR
BEGIN
  DECLARE "rv" long VARCHAR;
  SELECT "list"(DISTINCT "GetQuestAnswer"("t"."TagLocation","t"."TagID",@VacancyID),' ')
    INTO "rv"
    FROM "Tag" AS "t"
    WHERE "t"."TagLocation" LIKE 'V%' AND "t"."IncludeInKeyWordSearch" = 1 AND "t"."TagType" IN( 'T','U','L','M' ) ;
  RETURN "rv"
END

pears.VacancyKeyWordsQuestion

Original SQL

iqx