pears.CompanyKeyWordsQuestion

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

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

pears.CompanyKeyWordsQuestion

Original SQL

iqx