6 Replies - 638 Views - Last Post: 18 August 2009 - 09:22 AM Rate Topic: -----

#1 iqbalkmk  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 6
  • Joined: 18-August 09

Removing duplicates values....

Posted 18 August 2009 - 04:49 AM

I Have a database which are storing months....

i want to remove duplicates values from my database...

any one can help....?
Is This A Good Question/Topic? 0
  • +

Replies To: Removing duplicates values....

#2 tommyflint  Icon User is offline

  • D.I.C Addict
  • member icon

Reputation: 34
  • View blog
  • Posts: 679
  • Joined: 24-July 08

Re: Removing duplicates values....

Posted 18 August 2009 - 05:14 AM

What database is it? MySQL, MSSQL, Access?
Was This Post Helpful? 0
  • +
  • -

#3 iqbalkmk  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 6
  • Joined: 18-August 09

Re: Removing duplicates values....

Posted 18 August 2009 - 08:23 AM

View Posttommyflint, on 18 Aug, 2009 - 04:14 AM, said:

What database is it? MySQL, MSSQL, Access?




MSSql
Was This Post Helpful? 0
  • +
  • -

#4 tommyflint  Icon User is offline

  • D.I.C Addict
  • member icon

Reputation: 34
  • View blog
  • Posts: 679
  • Joined: 24-July 08

Re: Removing duplicates values....

Posted 18 August 2009 - 08:34 AM

This may help
http://support.microsoft.com/kb/139444

tommyflint
Was This Post Helpful? 0
  • +
  • -

#5 ForcedSterilizationsForAll  Icon User is offline

  • D.I.C Addict

Reputation: 33
  • View blog
  • Posts: 506
  • Joined: 16-July 09

Re: Removing duplicates values....

Posted 18 August 2009 - 08:37 AM

How is it storing the months? What other data is in that table? What are the primary keys? What are the foreign keys? If this is for homework related the answer is TRUNCATE TABLE, if this is for something other than school or homework related the answer is something different. ;)
Was This Post Helpful? 0
  • +
  • -

#6 iqbalkmk  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 6
  • Joined: 18-August 09

Re: Removing duplicates values....

Posted 18 August 2009 - 09:07 AM

View PostForcedSterilizationsForAll, on 18 Aug, 2009 - 07:37 AM, said:

How is it storing the months? What other data is in that table? What are the primary keys? What are the foreign keys? If this is for homework related the answer is TRUNCATE TABLE, if this is for something other than school or homework related the answer is something different. ;)


January February March April........Dec, year, date, Amount
Paid Paid 2000 12/09/2009 130
Paid Paid 2000 12/09/2009 130

i want remove this duplicate values from table using c#

Or prevent insert more values in january on same year...


There is no primary key used

This post has been edited by iqbalkmk: 18 August 2009 - 09:23 AM

Was This Post Helpful? 0
  • +
  • -

#7 ForcedSterilizationsForAll  Icon User is offline

  • D.I.C Addict

Reputation: 33
  • View blog
  • Posts: 506
  • Joined: 16-July 09

Re: Removing duplicates values....

Posted 18 August 2009 - 09:22 AM

How do you tie to this table? A little more info on what the purpose of the table is would be helpful.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1