I was watching all the discussions and apart from it trying to get the column added by my architect.

Adding the column is still going on..

It appears the design will...

Not a problem.

I will try to get a work around or request to add a new field to table.

Thanks very much for your responses. I appreciate it.

Please find more details with clear structures and sample data.

-- Table test

create table test

(col1 int identity(1,1),

col2 varchar(20),

year int,

qtr int

)

-- Table ident_map

create table ident_map

(old_ident int,

new_ident int

)

-- Insert sample records...

True. This is related to the post you have pointed. But the old post do not have much details and it created a lot of confusion who wanted to help...