SQL Table Question

[Jhibo]

Within our database, which runs on SQL, we have multiple tables one called Contact2. Seems in our Contact2 SQL table we have the same company with two rows. One row, with the old data and the other with the new data with the same ACCOUNTNO (which is unique to the record) on each row. Is this normal or do we have issues?
We found this problem by noticing that our database is pulling one row and our crystal reports is pulling another on certain records.

Thanks for your help

 

[tlbroadbent]

It isn't normal to have the same unique key on two rows. Your explanation suggests that the ACCOUNTNO is not defined as unique in the SQL Server table. Does the table have a primary key defined? Is the key defined on the ACCOUNTNO column, another coulmn or perhaps multiple columns? If no primary key is defined, does the table have a unique index? Primary keys, whichj are unique by definitrion, or unique constraints are required to guarantee uniqueness.

You should delete one of the duplicate rows. There are likely more duplicates for other ACCOUNTNOs. After deleting duplicates, add a unique constraint on the ACCOUNTNO column.

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm