the Identity column is not col1 thru col4, it is col12
I am just trying to insert from table1 to table2 (with a unique index) but i get duplicate errors when i try. I am just not good enough to figure out how to catch and insert those duplicate indexes
Col1, col2, col3, col4, ..., col12
AAA, 104, AAAAAA, 0, ...., 1
AAA, 104, AAAAAA, 0,...., 2
AAA, 104, AAAAAA, 1,...., 3
how should i go about inserting those values to the table2 but change the col4 values to 0,1,2.