On Tue, 2004-03-02 at 00:49, [EMAIL PROTECTED] wrote:
> what is the most performant way to select for example the first 99
> rows of a table and insert them into another table...
>
> at the moment i do this:
>
> for userrecord in select * from table where account_id = a_account_id
> and counte
Hi,
nobody has an idea? :-(
-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von [EMAIL PROTECTED]
Gesendet: Freitag, 27. Februar 2004 17:53
An: [EMAIL PROTECTED]
Betreff: [PERFORM] Select-Insert-Query
Hi,
what is the most performant way to select
On Friday 27 February 2004 16:52, [EMAIL PROTECTED] wrote:
*please* don't post HTML-only messages.
what is the most performant way to select for
> example the first 99 rows of a table and insert them into another
> table...at the moment i do this:
> for userrecord in select *
> from table where
Hi,
what is the most performant way to select for example the first 99 rows of a table and insert them into another table...
at the moment i do this:
for userrecord in select * from table where account_id = a_account_id and counter_id = userrecord.counter_id and visitortable_id between a_minid a
