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.
| 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 |
 |
|
|
|
|
|
Performance Issues - ID code