pears.NetQuestionGroupCountForDepartment

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

Original SQL

CREATE PROCEDURE "pears"."NetQuestionGroupCountForDepartment"( IN "pWebUserID" CHAR(20),IN "pDepartmentID" CHAR(20) ) 
RESULT( "pCount" INTEGER ) 
// IQXWeb
BEGIN
  SELECT "count"()
    FROM "IQXNetTagGroup"
    WHERE "iqxnettaggroupid" LIKE "isnull"("pDepartmentID",'')+'_%'
END /* DOC
2017-08-15 PC count question groups for departments where department group id has a structure including "_9"
 
*/
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetQuestionGroupCountForDepartment" IS 
{CREATE PROCEDURE pears."NetQuestionGroupCountForDepartment"(IN pWebUserID CHAR(20), IN pDepartmentID CHAR(20))
RESULT(pCount INTEGER)
// IQXWeb
BEGIN
	SELECT 
        COUNT(*)
    FROM 
        IQXNetTagGroup
    WHERE 
        iqxnettaggroupid LIKE isnull(pDepartmentID,'')+'_%'
END
 
/* DOC
2017-08-15 PC count question groups for departments where department group id has a structure including "_9"
 
*/
}