Re: Counter

From: Frank van Bortel <>
Date: Wed, 06 Feb 2008 19:26:19 +0100
Message-ID: <56bcc$47a9fbcb$524b5c40$> wrote:
> Hi All,
> I'm looking around right now to see if this is possible, but I thought
> I'd ask here too.
> Can you have a record counter in an insert statement? Something like
> this:
> INSERT INTO table_a (
> SELECT flda, fldb, fldc, i++, fldd FROM tableb);
> Basically there is one column that is a record counter. And since
> this is not a loop, I'm not sure how it is done. Maybe a sub-select
> with a count(*)??
> Thanks a bunch!



Frank van Bortel

Top-posting in UseNet newsgroups is one way to shut me up
Received on Wed Feb 06 2008 - 12:26:19 CST

Original text of this message