Results 1 to 2 of 2

Thread: insert issues

  1. #1
    Join Date
    May 2004

    Unanswered: insert issues

    I have a table that i'm using a bulk insert to add records to. my problem is that one of the columns in this table is Quantity. from this # i need to insert that many rows in another table using some of the values bulk inserted into table1. i was trying to use a trigger to do this, but i'm not sure how.

    any ideas????


  2. #2
    Join Date
    Jun 2003
    Provided Answers: 1
    A good general strategy to follow is to avoiding loading bulk data, throuch BCP, DTS, or anything else, directly into production tables.

    Load the data into a staging table first, and then use a stored procedure to process that data and move it into the productiont tables. Before the process completes it should delete all the succesfully loaded staging records. Anything left over in the staging table at completion can help you find bugs in your process.
    If it's not practically useful, then it's practically useless.

    blindman "sqlblindman"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts