====== pears.NetCandidateProvTimesheetForAuthoriseCount ====== Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. ===== Original SQL ===== create procedure "pears"."NetCandidateProvTimesheetForAuthoriseCount"( in "pWebUserID" char(20) ) result( "pResult" integer ) // IQXNet begin select "count"() from "netprovtimesheets"("pWebUserID",1) end go COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetCandidateProvTimesheetForAuthoriseCount" IS {create PROCEDURE pears."NetCandidateProvTimesheetForAuthoriseCount"(pWebUserID char(20)) RESULT(pResult integer) // IQXNet BEGIN select count(*) from netprovtimesheets(pWebUserID,1) END }