|
Aaron
Wouldnt that delete all of the
entries?
Steve
Hi George
Would something like the following work for
you?
DELETE
FROM YourTable
WHERE YourID IN
(SELECT YourID
FROM YourTable
GROUP BY YourID
HAVING COUNT(YourID) > 1)
HTH
Aaron
----- Original Message -----
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/
|
