Duplicate entry issue

14 Jul 2005 9:21 PM

Lontae Jones

Hello I have a table called log and the schema is below

Create table [log] ([AutoID] [int] IDENTITY (1, 1) NOT NULL ,
    [Timestamp] [smalldatetime] ,
    [PageSource] [varchar] (100),
    [Domain] [varchar] (100),
    [Faxedby] [varchar] (5),
    [Agent] [varchar] (10) ,
    [FaxPhone] [varchar] (14))

In the table I have duplcate rows. How can I get rid of one of them?

Example

1234 4:00:00 1 EXDOMAIN Sean (616)324-3232
1234 4:00:00 1 EXDOMAIN Sean (616)324-3232

14 Jul 2005 9:27 PM

Hari Prasad

Hi,

See the below URL:-

http://support.microsoft.com/default.aspx?scid=kb;en-us;139444

Thanks
Hari
SQL Server MVP

Show quote

"Lontae Jones" <LontaeJo***@discussions.microsoft.com> wrote in message
news:B4B1E7E1-8BB3-4E37-90E2-A35062B6D202@microsoft.com...
> Hello I have a table called log and the schema is below
>
> Create table [log] ([AutoID] [int] IDENTITY (1, 1) NOT NULL ,
> [Timestamp] [smalldatetime] ,
> [PageSource] [varchar] (100),
> [Domain] [varchar] (100),
> [Faxedby] [varchar] (5),
> [Agent] [varchar] (10) ,
> [FaxPhone] [varchar] (14))
>
>
> In the table I have duplcate rows. How can I get rid of one of them?
>
> Example
>
> 1234 4:00:00 1 EXDOMAIN Sean (616)324-3232
> 1234 4:00:00 1 EXDOMAIN Sean (616)324-3232