Re: Cursors ...

From: Sted Alana <Sted_Alana_at_hotmail.com>
Date: Wed, 08 May 2002 07:18:52 GMT
Message-ID: <3cd8d178$1_1@news.iprimus.com.au>

"Sybrand Bakker"
> >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
> >
>
>
> Unfortunately
> it's not allowed to use subselects in a cursor
>
> This is just plain utter nonsense.

It would be more helpful to him - and more constructive of you - if you provided an explanation as to why it is nonsense. Received on Wed May 08 2002 - 02:18:52 CDT