I meet a question.I need insert data from A table to B table.they are same structure,just data time different.A table content from 1/1/2010 to 10/1/2010,B table content from 9/1/2010 to now. (note I used SSIS bulk insert september month data from A
to B )
now I need insert three month 8,9,10 from A table to B table.when I insert data ,I meet this error
Violation primary key condition constraint , cannot insert duplicate index.becasue B table have
not use insert B from A where (WHERE DATA_TIME BETWEEN CAST('2010/08/01 00:00:00' AS DATETIME) AND CAST('2010/09/30 23:59:59' AS DATETIME)
who can help me resoveing this issue,thanks a lot!!!
View Complete Post