how to store multiple rows in a stored procedure's parameters and then insert them in a table

• Bhuvnesh

  SSC Guru

  Points: 59351

  More actions

  October 17, 2013 at 6:33 am

  #1659283

  aeri_q (10/17/2013)

  ---

  it returns 3 rows for a specific table of my database.

  But when i wrote stored procedure using the same query it inserted the first row in my table. (The first of the 3 rows which where returned by the query,when executed alone)

  it will because .

  you below query will basically executed ONE time during every Sp execution and fill all the variable of INSERT statement once.

  INSERT INTO SY.DB03F(FKNAME,SCHM,FKFLD,FKTBL,PKFLD,PKTBL)

  VALUES(

  @FKNAME,

  @SCHNAME,

  @FKFLDNAME,

  @FKTBLNAME,

  @PKFLDNAME,

  @PKTBLNAME)

  Instead .... go with the query which OTF mentioned and use it in place of above SQL insert. .

  -------Bhuvnesh----------
  I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

• aeri_q

  Mr or Mrs. 500

  Points: 553

  More actions

  October 17, 2013 at 6:45 am

  #1659291

  Ohh thank you so much ,

  It was just a little and silly mistake i was doing .

  INSERT ..SELECT works fine in this case .

• OTF

  SSCertifiable

  Points: 6104

  More actions

  October 17, 2013 at 6:49 am

  #1659294

  Glad we could help.