Date: Wed, 6 Feb 2008 07:04:35 -0800 (PST)
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