troubleshooting Question

Remove Duplicate Rows

Avatar of Collezione
Collezione asked on
Microsoft SQL Server 2005
6 Comments1 Solution308 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
Aneesh
Database Consultant
Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros