Sorry can't help it but say that is a really bad solution for generating unique values.. Why not use a combination of first name, last name plus another unique value like maybe the birthday and zip code or something to generate that unique value? You would have a far greater chance for two John Smiths not to be born on the same day from the same zip code.....
Joe ________________________________ From: Hyunkel v2.0 <lord_dyna...@hotmail.com> To: arslist@ARSLIST.ORG Sent: Friday, April 17, 2009 1:00:55 AM Subject: Sybase ** Hi Listers: I'm running out with an issue with Sybase I have a table with some duplicate values, like this: First Name | Last Name | Customer ID | entry id John | Smith | 1 | 123 John | Smith | 2 | 124 John | Simmons | 3 | 125 John | Simmons | 4 | 126 I run from remedy a sql to synchronize the Customer ID and set it as "First Name+Last Name" so the result table must be: First Name | Last Name | Customer ID | entry id John | Smith | JohnSmith | 123 John | Smith | JohnSmith | 124 John | Simmons | JohnSimmons | 125 John | Simmons | JohnSimmons | 126 But The Customer ID must be a unique value, so this rule generates that exists on the system duplicate records. I need to find a SQL statement that: * Identify duplicate records. * Let set as Customer ID the entry id value I'm usign sybase 13, actually i have sql sentences to give the number of duplicate records, but those don't let me update due the subquery returns more than 1 row. Any thoughts? Any help will be appreciate Best Regards Hugo Ruesga perotsystems® US 972.577.7000 MX +52 (33) 3332.3868 PPlease consider the environment before printing this email The information contained in and transferred with this electronic message is intended only for the recipient(s) designated above, it is protected by law and it may contain information which is privileged and confidential. If you are not the intended recipient, please do not read, copy, or use it, and do not disclose it to others. Please notify the sender of the delivery error by replying to this message, and then delete it from your system. Thank you. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"