If there are 2 industry codes with the same employment in a region, then the smallest industry code should be selected. The ddl for this table is below:

CREATE TABLE rpt_calc_data...

Thanks!  That did the trick.

-Adrianne

Thanks for the info.  I tried what you said, using the code below, but got an error message: Could not find stored procedure 'alter table test add 1990q4 int'.

Here's the...

Thanks! That worked!