select distinct column1, column2,...,LastColumn
> -----Original Message-----
> From: aslam bajaria [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 02, 2000 15:31
> 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/[email protected]/
> > 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/[email protected]/
> > 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/[email protected]/
> 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/[email protected]/
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.
