🚀 go-pugleaf

aleplgr wrote:

> 
> Hi! I have a table with 80 columns, I need to select 3 of them:
> CLIENTID, DATE1 and DATE2 and order them by CLIENTID, DATE1   and
> then create another column that is a sequencial number (a generator)
> that reflects that order.  I need this to be a new table because I've
> done a stored procedure assuming that I have this 4 columns table
> which one of them is a generator.  I can only add a generator in an
> INSERT sentence but I can't INSERT in order because IB 7.5 does not
> let me do it so I don't know how to add a generator in the order I
> need...

I assume you are using a temporary table and putting the data into the
table with and INSERT INTO...SELECT...FROM statement. Is this correct?

Does the sequential number have to start with 1?

You could write a stored procedure that inserts the data then use a FOR
SELECT statment to loop through the records and update the sequential
number field using an integer variable as the counter.

-- 
Bill Todd (TeamB)