I created a store procedure which needs to return totals from different terminals. It works fine when theres only 1 terminal. If there is more then 1 terminal I get an error

"Multiple rows in Single Select" . How do i fix my code to allow for multiple rows.

Thank you in advance for any solution.

Here is my store procedure.

....

AS

BEGIN

SELECT TERMINAL, SUM(TOTAL) FROM DOCKETS

GROUP BY TERMINAL

INTO :TERMINALID, :STOTAL;

SUSPEND;

END

...


|


---------------------------------
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!

[Non-text portions of this message have been removed]