Home Forums SQL Server 2008 SQL Server Newbies how to store multiple rows in a stored procedure's parameters and then insert them in a table RE: how to store multiple rows in a stored procedure's parameters and then insert them in a table

  • October 17, 2013 at 6:27 am

    #1659281

    aeri_q (10/17/2013)

    I am doing it row by row because i think its the only way to do this .

    The query i have mentioned, if run directly in TSQL ..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)

    Assuming your plan is to insert all rows from your output into your table, does my earlier response not help?