This stored procedure returns:
PREP Shawnee KS 10/01/2015 - 10/06/2015 248
RES Wyandotte KS 10/01/2015 - 10/15/2015 4
SET TERM ^^ ;
CREATE PROCEDURE SPS_DOCKET_WORKLIST_LIST returns (
WORKLIST_NAME VarChar(60),
WORKLIST_COUNT SmallInt)
AS
begin
FOR SELECT DISTINCT WORKLIST_NAME
FROM DOCKET_WORKLIST
INTO :WORKLIST_NAME DO
BEGIN
SELECT COUNT(*)
FROM DOCKET_WORKLIST
WHERE WORKLIST_NAME = :WORKLIST_NAME
INTO :WORKLIST_COUNT;
SUSPEND;
END
end ^^
SET TERM ; ^^
I know there is a way to do this with a SQL select statement. Can someone
share how?
Thanks,
Mike
