Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 id problem

Author  Topic 

berinder
Starting Member

18 Posts

Posted - 2001-08-02 : 11:10:45
hello,

We are getting updates to a table from another company, when the lowlifes added the prices they did it by turning of unice id's and putting over the rows with their id.

result, well, duplicate id's.

Is there any easy way to reorder the id's.. we have no constarints that will get messed up by this...

either a reorder of them all, or just taking out the duplicates and give the duplicate a new number.

thanks in advance!

   

- Advertisement -