Re: Re: Re: Getting the number of rows returned by a select with group by.

Besides... Let say you call stored procedure for every row in a query, _and_ inside the stored procedure you create and drop a temporary table... I had a lot of problems doing this, unitl someone give a solution to this by using exceptions... I think no problem exist by using _derived tables_ . Chucho! -----Original Message----- From: "rkusenet" <rkusenet@gmail.com> .. The problem comes in stored procedures where creation/destruction of a temp table inside the SP forces the engine to recompile, which in turn puts a lock on sysprocplan... Jean Sagi jeansagi@myrealbox.com jeansagi@yahoo.com sending to informix-list