Fixing duplicates

  • An article that looks at the problem of getting duplicate data, for example, invoices. Imagine I have a software bug and get duplicates. How can I update the duplicates to take new values, say the next set of values in a range.

    If I have

    1001

    1001

    1002

    1002

    1003

    1003

    How can I get

    1001

    1002

    1003

    1004

    1005

    1006

    with minimal renumbering.

  • I can do this one.

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • Great, and thanks.

  • Ha, wrote and submitted an article, but for the wrong duplicates problem. I'll work on this one now.

    Sorry!

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • No worries. I'll review it and see how it looks. We can always use another one.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply