Entering duplicates in a Primary Key column

• Pappo

  SSC-Addicted

  Points: 473

  More actions

  November 2, 2005 at 5:10 pm

  #364002

  I have a table with the fields acct_id,program_id and a datestamp. Both the acct_id and program_id are primary keys.

  An acct_id can have a different program_id in different years. So there are some duplicate acct_ids with different program_ids, depending on the year. An acct_id cannot have the same program_id duplicated in the same year.

  When I try to make new insertions, I get this error message :

   Violation of PRIMARY KEY constraint 'PK_tableName. Cannot insert duplicate key in object 'tableName'. The statement has been terminated.

  How can I make insertion into this table?

• Sergiy

  SSC Guru

  Points: 110208

  More actions

  November 2, 2005 at 5:35 pm

  #602022

  Add year to PRIMARY KEY.

  _____________
  Code for TallyGenerator