Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $95

removing duplicates from a table

Discussion in 'Information Technology' started by Christopher Buxton, Jul 28, 2006.

  1. Christopher Buxton

    Christopher Buxton
    Expand Collapse
    Guest

    I have a table that keeps a record of the job number. I the past we have
    allowed duplicate jobs in the database. We have recently adjusted the tables
    so we now have two linked tables instead of the one to reduce the amount of
    data we presently duplicate.

    I have copied the relevent fields from the main table into the new one
    leaving just some vital details within the main table. these details remain
    constant against a specific job number. my problem is that i now wish to make
    the job number the index (without duplicates). is there a way of getting
    access to strip out the duplicate records as i don't fancy having to trail
    through 40,000 records removing the duplicates.

    thanks chris
     
  2. Loading...


  3. Jason Martin

    Jason Martin
    Expand Collapse
    Guest

    http://support.microsoft.com/kb/109329/en-us

    I always check Microsoft's KB first. 99/100 times it's there. Best KB on
    the net.

    - Jason

    "Christopher Buxton" <ChristopherBuxton@discussions.microsoft.com> wrote in
    message news:C0CDEC6F-4961-49F1-97F5-07DFD1BB9E0E@microsoft.com...
    >I have a table that keeps a record of the job number. I the past we have
    > allowed duplicate jobs in the database. We have recently adjusted the
    > tables
    > so we now have two linked tables instead of the one to reduce the amount
    > of
    > data we presently duplicate.
    >
    > I have copied the relevent fields from the main table into the new one
    > leaving just some vital details within the main table. these details
    > remain
    > constant against a specific job number. my problem is that i now wish to
    > make
    > the job number the index (without duplicates). is there a way of getting
    > access to strip out the duplicate records as i don't fancy having to trail
    > through 40,000 records removing the duplicates.
    >
    > thanks chris
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page