|
Can you temporarily (or permanently) add an identity field
to the table? That will give each record a unique id.
----- 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/
|
