Welcome to SPN

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

Sign Up Now!

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
     

Share This Page