Counter

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! Received on Wed Feb 06 2008 - 09:04:35 CST