Posted by: arnzombie June 9, 2008
SQL Automatic incremental generator
Login in to Rate this Post:     0       ?        

First, Do you really want duplicate values on Table B. If yes why do  you have unique index. Simply drop the index and you should be fine.

Secondly, Wat kinda value do you want in Table B. Are you trying to insert from table A.

Can you be more specific on the value you want on table B and why are you inserting duplicate values and how do you want that to be handled.

Read Full Discussion Thread for this article