pears.NetReportCombo_ClientSite

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

Original SQL

CREATE PROCEDURE "pears"."NetReportCombo_ClientSite"( IN "pWebUserID" CHAR(20) ) 
RESULT( "Description" CHAR(250),"Value" CHAR(250),"SortStr" CHAR(250) ) 
BEGIN
  SELECT DISTINCT "getCompanyAddressOnline"("company"."companyid") AS "Descr","company"."companyid",IF("isnumeric"("left"("Descr",1)) = 1) THEN "right"("Descr","length"("Descr")-"charindex"(' ',"Descr")) ELSE "Descr" endif AS "SortStr"
    FROM "company" KEY JOIN "employment" KEY JOIN "iqxnetuserlink" WHERE "iqxnetuserlink"."iqxnetuserid" = "pWebUserID" ORDER BY "SortStr" ASC
END
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetReportCombo_ClientSite" IS 
{CREATE PROCEDURE pears.NetReportCombo_ClientSite(IN pWebUserID CHAR(20))
RESULT(Description CHAR(250),VALUE CHAR(250),SortStr CHAR(250))
BEGIN
  SELECT DISTINCT getCompanyAddressOnline(company.companyid) AS Descr,company.companyid,IF(isnumeric("left"(Descr,1)) = 1) THEN "right"(Descr,LENGTH(Descr)-charindex(' ',Descr)) ELSE Descr
    endif AS SortStr FROM company KEY JOIN employment KEY JOIN iqxnetuserlink WHERE iqxnetuserlink.iqxnetuserid = pWebUserID ORDER BY SortStr ASC
END
}