Another SQL Server command to find dups: SELECT Field1, COUNT(*) FROM FormName GROUP BY Field1 HAVING COUNT(*) > 1
Stephen Remedy Skilled Professional -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L Contr OC-ALC/ITMA Sent: Tuesday, September 18, 2007 2:12 PM To: [email protected] Subject: Re: Making a field in the form as unique index that leardy has duplicate values. I believe you must go in first and change/delete the tickets. The system will fail to build the index if there are duplicate values. I would suggest going on the database level to find the duplicate tickets. You can join the table with itself to find them. For instance, to find tickets that have duplicate values for 'Field1' you can use: Select record_id from <table> a, <table> b where a.record_id != b.record_id and a.field1 = b.field1 You may have to tweak the syntax a bit, but this should give you a list of all duplicate records. Thanks, Gary Opela, Jr Sr. Remedy Developer Leader Communications, Inc. 405 736 3211 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ravi Sent: Tuesday, September 18, 2007 1:08 PM To: [email protected] Subject: Making a field in the form as unique index that leardy has duplicate values. Hi: I have a form which already has data. I want to make a field value Unique in the form properties. Some of the records already have duplicate values for this field. Will the system delete these records or change the field values? Thanks Ravi ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
