Hi folks,
I have a database table named TSALES7_V2.How can I remove duplicate rows of this table? Is it possible reduce the repetiton number to one? I need just one of these duplicated rows..
Please help
my table looks like this:
CREATE TABLE [dbo].[TSALES7_V2] (
[D_DATE5] [varchar] (72) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[DCURR] [varchar] (72) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[DORGAN] [varchar] (72) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[DVERSION] [varchar] (72) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[DYIL] [varchar] (72) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[DSEZON] [varchar] (72) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[DCT] [varchar] (72) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[DURUNTIP] [varchar] (72) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[DTERMIN] [varchar] (72) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[DSES] [varchar] (72) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[DKUMAS] [varchar] (72) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[DCINS] [varchar] (72) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[MODEL] [int] NULL ,
[SATMIK] [int] NULL ,
[SATTUT] [float] NULL ,
[INDIRIM] [float] NULL ,
[ORTFYT] [float] NULL ,
[BRSATTUT] [float] NULL ,
[HEDEF] [float] NULL ,
[StatusFlag] [bit] NULL ,
[VALUE] [float] NULL ,
[Cinsiyet] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Daciklama] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
select distinct * into NewTable from tsales7_v2
truncate table tsales7_v2
insert into tsales7_v2
select * from NewTable