[cfaussie] Re: How can I remove duplicate records in SQL Server 2000?

[George Lu]

Thanks Peter. I think the problem occurred when I transferred data from Access to SQL Server and I've forgot to enable "identify" for the ID field.   George >>> [EMAIL PROTECTED] 9/06/04 21:25:04 >>> If you use an "indentity" field you wouldn't get two record ID's that are the same.   I think it is bad database design on your part for this to occur. Peter Tilbrook Manager, ACT and Region ColdFusion Users Group - http://www.actcfug.com 4/73 Tharwa Road Queanbeyan, NSW, 2620 AUSTRALIA Telephone: +61-2-6284-2727 Mobile: +61-0439-401-823 E-mail: [EMAIL PROTECTED] >> My game time with Halo 2 was but a fleeting glimpse, yet it's haunted me ever since ... kinda like seeing your parents naked. <<   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Lu Sent: Wednesday, 9 June 2004 9:38 AM To: CFAussie Mailing List Subject: [cfaussie] Re: How can I remove duplicate records in SQL Server 2000? Yes, I can. But I don't want two records with same ID (and same value in all other fields). >>> [EMAIL PROTECTED] 9/06/04 9:18:40 >>> Can you temporarily (or permanently) add an identity field to the table? That will give each record a unique id. ----- Original Message ----- From: George Lu To: CFAussie Mailing List Sent: Wednesday, June 09, 2004 9:07 AM Subject: [cfaussie] How can I remove duplicate records in SQL Server 2000? Hi,   Somehow I don't know what happened I've got duplicate records (two records have same value in all fields including ID). I can't set primary key since ID field is duplicated.   Could anyone tell me how to remove the duplicate record or merge two duplicated records into one in SQL or CF?   Thanks, George --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ AMES (Adult Multicultural Education Services) www.ames.net.au Disclaimer ********************************************************************** This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments you should check them for viruses or defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of Adult Multicultural Education Services (AMES). ********************************************************************** --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ AMES (Adult Multicultural Education Services) www.ames.net.au Disclaimer ********************************************************************** This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments you should check them for viruses or defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of Adult Multicultural Education Services (AMES). ********************************************************************** --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ AMES (Adult Multicultural Education Services) www.ames.net.au Disclaimer ********************************************************************** This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments you should check them for viruses or defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of Adult Multicultural Education Services (AMES). ********************************************************************** --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/