Cursors ...

From: Meinhard Schnoor-Matriciani <Meinhard_at_NewYorker.de>
Date: Mon, 6 May 2002 23:20:25 +0200
Message-ID: <1020720050.690708@beavis>

Hi togehter !

I am in the need of writing a SP which generates new rows i a table. I am doing that using a cursor and loop through the result set. Unfortunately it's not allowed to use subselects in a cursor, so wrote a set of function which return the requested column values. Now the problem ist, that this technique seems to consume a lot of time ( 500msec with the functions , 20ms in interactive mode using subselects ). Does anybody have an advice what to do ?

TIA
Meinhard Received on Mon May 06 2002 - 16:20:25 CDT