Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2003
    Location
    New York, NY
    Posts
    136

    Question Unanswered: Inserting a tabular data

    Need some suggestions on how to insert a tabular data in a table. we have a deal table and lets say a particular deal has 10 rows (and 25 columns). user makes some changes to one of the 10 rows, while saving all the 10 rows have to be inserted with a new version id. so everytime a new version is to be created, all 10 rows should be added to the table in one transaction.

    whats a good way to do that...xml is one option...what else?

  2. #2
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    what do you mean by tabular data? csv? if so bcp.exe is one good way to go.

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Are you calling a sproc?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  4. #4
    Join Date
    Sep 2003
    Location
    New York, NY
    Posts
    136
    by tabular data I mean multiple rows for a single deal...not one single row...
    for eg. deal A has 10 rows and 37 columns and deal B has 23 rows and 37 columns.

    yes Brett the insertion has to be through a sproc.

Posting Permissions

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