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 2008 Forums
 Other SQL Server 2008 Topics
 Performance Issues - ID code

Author  Topic 

MelTed
Starting Member

9 Posts

Posted - 2014-09-18 : 11:42:36
Greetings all,

I have an issue with SQL server. I would appreciate if someone can give some guidance please.
Issue:
The query script does not recognize the MAX ID code in the table (ID code is generate by a function and is Alphanumeric).

Background:
The ID code is Alphanumeric and generated by a function in our application. We had a previous issue whereby ID codes were getting duplicated. As bad as this sounds, we manually reassigned codes to the records that were dulicated then applied the Unique constraint to the ID field to prevent further duplication. So when the application ran, the query did not recognize as valid the fields manually adjusted in the database. So the query script viewed as max the last filed generated by the function.

Any ideas please....?

Regards

Arun Babu N
Starting Member

26 Posts

Posted - 2014-09-19 : 04:19:14
please share the function.

It is a work around. Manally run the function till the max value present in a table.

arunbabu
Go to Top of Page
   

- Advertisement -