I need a trigger that updates a character-based column in a
System Numbers table with zero-prefixed, 8-digit incrementing
values. For example, I want to assign the value 00000001 to the
first inserted row, the value 00000002 to the second row, and so
on. The trigger works fine on a one-row insert. But if I use the
following statement:  INSERT INTO NewTable (x,y,z)    SELECT x,
y, z    FROM OldTable  and I'm inserting more than one row, the
only row that the trigger updates is the last row inserted.
Listing 3 shows how the incrementing column value is calculated.
I'm trying to avoid using a cursor that loops through each
record of OldTable. Will SELECT INTO let me do this, or should I
bite the bullet and use a cursor?  No, you don't have to use a
cursor. Instead, you can use a set-based approach to solving the
problem. Let's expand and explain your request and your code a
little further. A table called Sysfile in your database contains
a column named Next_Ach_Trans#. This column holds an integer
sequence that