OK so my application creates a temp table that is almost the same as the regular table . I will post a picture. When I try to insert the data from the regular data to the temp data I get an error.
I get the error regardless if I do it from the application or by SQL statement. I checked for duplicates and their are none and there are no null values in my data
I tried to insert the data manually using this statement.
INSERT INTO tblEquipPanelBreaker_Temp ( keyBreaker, keyEquip, numBreakerPosition, numBreakerDetailRow, strBreakerSize, optA103, keyCableDn, [Phase 1], [Phase 2] )
SELECT keyEquipPanelBreaker, keyEquip, numBreakerPosition, numBreakerDetailRow, strBreakerSize, optA103, keyCableDn, strPhase1, strPhase2
FROM tblEquipPanelBreaker
Below are some pics, the first table has the data the second table is my temp table which I am trying to push the data into. Contrary to the error there were no records locked and I cannot see how there would be a key violation. Any suggestions would be appreciated.