primary key duplication
-
hi i am facing one starnge problem............... I have one table in SQL DB which has following constraints........ Indexes IX_InvoiceTaxDetails_InvoiceDetailIndex clustered located on PRIMARY InvoiceDetailIndex PK_InvoiceTaxDetails nonclustered, unique, primary key located on PRIMARY InvoiceTaxDetailsIndex Constarints FOREIGN KEY FK_InvoiceTaxDetails_InvoiceDetail No Action No Action Enabled Is_For_Replication InvoiceDetailIndex REFERENCES BMJ.dbo.InvoiceDetail (InvoiceDetailIndex) FOREIGN KEY FK_InvoiceTaxDetails_TaxCombinationsDetails No Action No Action Enabled Is_For_Replication TaxCombinationsDetailsIndex REFERENCES BMJ.dbo.TaxCombinationsDetails (TaxCombinationsDetailsIndex) PRIMARY KEY (non-clustered) PK_InvoiceDetailIndex (n/a) (n/a) (n/a) (n/a) InvoiceTaxDetailsIndex Even though i have defined Primary key On column InvoiceTaxDetailsIndex my table has multiple data with same Value in InvoiceTaxDetailsIndex field e.g InvoiceTaxDetailsIndex InvoiceDetailIndex TaxCombinationsDetailsIndex TaxAmount TaxValueSlabIndex FoxUpdate UpdateDateTime ---------------------- ------------------ --------------------------- ----------------------------------------------------- ----------------- ------------------------------------------------------ ------------------------------------------------------ 305123 143171 2803 778.57000000000005 561 NULL 2005-11-19 19:55:34.763 305123 143171 2803 778.57000000000005 561 NULL 2005-11-19 19:55:34.763 can any one tell me what could be the reason.......... Regards, Ritesh