Re: SQL question

This doesn't work

Jason

On 20 Mar 1998 05:16:40 GMT, radstorms_at_aol.com (Radstorms) wrote:

>>How can I use SQL to remove dup lines and just keep the first line in each
>>group?
>>
>>
>
>Obviously your table does not have a "clustered index" on it, otherwise you
>would not be faced with duplicate rows. If this is true, then you can create a
>"clustered index" on the table containing the "quote_id" and "price_class"
>columns with the "ignore_dup_rows" option. This will remove any duplicate rows
>automatically. Then after the index is created and dup rows removed you can
>drop the index. Everything will be back to where you want it. The following
>code will accomplish this:
>
>1> create clustered index index_name on table_name
>2> with ignore_dup_row
>3> go
>
>I would try this out on test data before doing it on any PROD data. Good luck.
>
>-->Roger
Received on Tue Mar 24 1998 - 00:00:00 CET