Try
SELECT DISTINCT col1, col2, ...
FROM <table_name>
WHERE 1=1
(* Notice the absence of Parens)
-Kevin
-----Original Message-----
From: aslam bajaria [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 02, 2000 10:31 AM
To: [EMAIL PROTECTED]
Subject: RE: Help! (2)
select distinct(*) gives an error.
Also
select distinct(column1, column2,...,LastColumn) gives
an error.
Can someone tell me how to avoid this error.
Appreciate.
A.B.
--- Johan Coens <[EMAIL PROTECTED]> wrote:
> Maybe:
>
> Step 1: SELECT DISTINCT ... (all colums), name it
> qryAllRecords
> Step 2: DELETE FROM <yourtable>, now you're table is
> empty
> Step 3: LOOP over qryAllRecords and insert them into
> the database.
>
> Make sure you have a backup and use CFTRANSACTION!
>
> Best Regards,
> Johan Coens
>
> -----Original Message-----
> From: aslam bajaria [mailto:[EMAIL PROTECTED]]
> Sent: woensdag 2 augustus 2000 6:30
> To: [EMAIL PROTECTED]
> Subject: Help!
>
>
> Hello All,
> There is a very seriuous problem I am facing. Please
> help. The problem is as follows:
>
> Somehow I have created duplicate records in SQL
> Server
> 7.0 table.
>
> I have to remove the duplicate the records. It all
> happened because there is no primary key when the
> record was created.
>
> If it were a few records, I could have manually
> deleted them. Now the records are in thousands. Can
> someone suggest me a code that would check for
> duplicate values in a table and delete them.
>
> Please help.
>
> A.B.
>
> __________________________________________________
> Do You Yahoo!?
> Kick off your party with Yahoo! Invites.
> http://invites.yahoo.com/
>
----------------------------------------------------------------------------
> --
> Archives:
>
http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
>
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
> or
> send a message to [EMAIL PROTECTED]
> with 'unsubscribe' in
> the body.
>
>
----------------------------------------------------------------------------
--
> Archives:
>
http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
>
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
> or send a message to
> [EMAIL PROTECTED] with 'unsubscribe'
> in the body.
__________________________________________________
Do You Yahoo!?
Kick off your party with Yahoo! Invites.
http://invites.yahoo.com/
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
