Updating Table in SQL

From: squarepants4117 (squarepants4117_at_discussions.microsoft.com)
Date: 09/16/04

  • Next message: squarepants4117: "Updating Table in SQL" 
    Date: Wed, 15 Sep 2004 17:11:20 -0700

     I have a program that will allow me export daily transactions from a
    particular software package. This file is exported as "invoice.dbf" each
    day. I have imported the file into SQL server and can see the data and have
    no issues. The problem is that it is possible to export for more than one
    day and therefore have duplicated information once it is imported into SQL
    server table. I need a way so if it happens that the info is "bridged" out
    of outside program and brought into database table and it is a duplicate it
    won't be brought into the table. There is one caveat and that is that if the
    cashier lists the same item 10 times on an invoice then then that is a "good"
    duplicate and I would need that to be brought in. I have gotten around that
    issue by making a column in the table that is anidentiy field so that each
    record is assigned a sequential number. Therefore by keying the sale ID and
    this seq number I can get a unique record. I am a newbie at this and am not
    sure if this is even the best way to do that, but to make a short story long
    , I was wondering how to keep duplicate data from being brought into the
    database table using a query in DTS

  • Next message: squarepants4117: "Updating Table in SQL"

    Relevant Pages

    • How to remove code?
      ... I have been having alot of grief with my database these couple of days. ... create duplicate values in the index, primary key, or relationship. ... the data in the field or fields that contain duplicate data, ... I managed to delete the report that seemed to be the problem but now it ...
      (microsoft.public.access.forms)
    • Updating Table in SQL
      ... duplicate and I would need that to be brought in. ... this seq number I can get a unique record. ... I was wondering how to keep duplicate data from being brought into the ... database table using a query in DTS ...
      (microsoft.public.sqlserver.mseq)
    • sqlexception - PK violation
      ... When I try to insert a record in database with a PK that already exists I ... Change the data in the field or fields that contain duplicate data, ... Roel ...
      (microsoft.public.dotnet.languages.csharp)
    • sqlexception - PK violation
      ... When I try to insert a record in database with a PK that already exists I ... Change the data in the field or fields that contain duplicate data, ... Roel ...
      (microsoft.public.dotnet.framework.aspnet)
    • Re: Paste append error message
      ... I start wondering about my virus checker. ... to access 2003 and the duplicate button works fine. ... I plan to use the database at work on the network (we're still running ... I have to set this up on the network at work on Saturday ...
      (microsoft.public.access.gettingstarted)