What is the best way to insert data into database sqlserver 2005 in one to many relation with multiple records(>100s)?

• newbie8310

  SSC Rookie

  Points: 26

  More actions

  June 26, 2013 at 10:22 pm

  #295736

  Hi, All, I have a problem when inserting record into database sqlserver two tables ( 1-n),

  ex: table1(id,name,totalamt)

  table2(id,subid,amt,price)

  i want use store proc with parameter ( list record in table2 > 100s) to insert data into 2 tables( using transaction in store), i hope i will be supported from every body?

  thanks all

• Kingston Dhasian

  SSCoach

  Points: 19799

  More actions

  June 27, 2013 at 4:04 am

  #1627892

  I am not really clear what your requirement is.

  You can probably explain it much better with some DDL, sample data( may be some 10 - 20 rows ) and the expected results based on the sample data

  If you are not sure about how to provide this, please refer the link in my signature for detailed information

  ---

  Kingston Dhasian

  How to post data/code on a forum to get the best help - Jeff Moden
  http://www.sqlservercentral.com/articles/Best+Practices/61537/